NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases, newest first

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB MIA00LA111Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLThe pilot's improper collective and cyclic control usage during an emergency descent, following the onset of a 1 to 1 vibration for undetermined reasons, resulting in the helicopter landing hard and rolling over.Mar 17, 2000 · N5304V · Substantial damageNTSB MIA00LA110Accident · Minor injuriesLimited investigationFinal reportAeronca-Bubeck Irving BUBECK-AERONCA · Merritt Island, FLThe flight instructors inadequate supervision of the dual student resulting in the student pushing forward on the control stick during a bounced landing until the aircraft impacted the runway, bounced, landed hard, and broke the main landing gear.Mar 17, 2000 · N6030T · Substantial damageNTSB SEA00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Three Forks, MTThe pilot's failure to maintain directional control of the tailwheel equipped airplane.Mar 16, 2000 · N2873Z · Substantial damageNTSB SEA00LA052Accident · No injuriesLimited investigationFinal reportCessna A185-F · Bend, ORThe pilot's failure to adequately compensate for wind conditions.Mar 16, 2000 · N1357M · Substantial damageNTSB MIA00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLSeparation of the right main landing gear tire recap during takeoff resulting in the pilot's loss of directional control, the aircraft departing the runway, collapse of the landing gear, and collision with the airport fence.Mar 16, 2000 · N251RS · Substantial damageNTSB LAX00LA128Accident · Serious injuriesLimited investigationFinal reportAero Commander 100 · Buckeye, AZThe pilot's improper judgment and his failure to maintain clearance from the ground. A factor was the pilot's lack of recent experience.Mar 16, 2000 · N3896X · Substantial damageNTSB FTW00LA099Accident · No injuriesLimited investigationFinal reportCessna 402C · San Antonio, TXThe pilot's inadequate handling of the aircraft during the landing flare/touchdown resulting in a hard landing that collapsed the left main landing gear.Mar 16, 2000 · N11NX · Substantial damageNTSB DEN00LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Provo, UTThe pilot misjudging the flare. Factors were dark night conditions, and the pilot's lack of recent experience in the type of operation (night landings).Mar 16, 2000 · N367T · Substantial damageNTSB DEN00LA060Accident · No injuriesLimited investigationFinal reportBeech B55 · Ogden, UTInadvertent landing gear retraction by person(s) undetermined. A factor was the inadequate supervision of the flight by the flight instructor.Mar 16, 2000 · N13RJ · Substantial damageNTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.Mar 15, 2000 · N569JH · Substantial damageNTSB LAX00GA114Accident · Minor injuriesFinal reportBell OH-58C · Compton, CAAn undetermined electrical system voltage surge.Mar 15, 2000 · N911JN · DestroyedNTSB MIA00IA104Incident · No injuriesIncident investigationFinal reportBeech 58 · Memphis, TNfailure of the right main landing gear's dynamic brake relay, that resulted in the motor driving the gearbox past prescribed limits, resulting in a bent connecting rod, and failure of the gear to extend.Mar 14, 2000 · N225TA · Minor damageNTSB MIA00FA107Accident · No injuriesField investigationFinal reportCessna 310D · Stuart, FLthe failure of both pilots to maintain an adequate visual lookout, resulting in both airplanes colliding in flight. Contributing to the accident were: 1) inadequate approach/departure control service by ATC approach/departure personnel, and the failure of the…Mar 14, 2000 · N6744T · 2 aircraft · Minor damageNTSB LAX00IA127Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · San Francisco, CAfailure of the right main landing gear to fully extend for undetermined reasons.Mar 14, 2000 · N516DA · Minor damageNTSB FTW00LA096Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Rayville, LAThe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the dark night light condition.Mar 14, 2000 · N2832W · Substantial damageNTSB DEN00LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Rifle, COLoss of engine power for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.Mar 14, 2000 · N8236M · Substantial damageNTSB SEA00LA051Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Odell, ORThe pilot's failure to maintain sufficient altitude over, or clearance with, a tree. Factors contributing to the occurrence of the accident were the tree and sharply rising terrain. A factor contributing to the severity of the accident was a post-crash fuel…Mar 13, 2000 · N9040V · DestroyedNTSB LAX00TA125Accident · Serious injuriesFinal reportPiper PA-18-150 · Rio Vista, CAfailure of the pilot to maintain clearance from power lines while maneuvering at a low altitude. A factor was glare from the sun.Mar 13, 2000 · N82751 · Substantial damageNTSB FTW00LA110Accident · No injuriesLimited investigationFinal reportCessna A188B · Perryton, TXThe pilot's failure to maintain directional control during the takeoff roll. A factor was the crosswind.Mar 13, 2000 · N4833Q · Substantial damageNTSB FTW00LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe failure of the left magneto, which resulted in the partial loss of engine power during takeoff.Mar 13, 2000 · N6637 · Substantial damageNTSB FTW00LA097Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Gillett, ARThe cracked #8 cylinder resulting in failure of the cylinder. A factor was the plowed/furrowed terrain.Mar 13, 2000 · N9785 · Substantial damageNTSB DEN00LA058Accident · No injuriesLimited investigationFinal reportBeech A23A · Rawlins, WYThe pilot's failure to abort the landing in a timely manner. Factors were the tailwind and high density altitude, resulting in inadequate climb performance.Mar 13, 2000 · N2337W · Substantial damageNTSB SEA00IA050Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe flight crew's encounter with a suspicious device, which necessitated an emergency evacuation.Mar 12, 2000 · N974AS · Minor damageNTSB LAX00LA124Accident · Minor injuriesLimited investigationFinal reportBell 47G · Vacaville, CAFailure of the pilot to see wires and maintain clearance while flying at a low altitude.Mar 12, 2000 · N9763Z · Substantial damageNTSB IAD00IA026Incident · No injuriesIncident investigationFinal reportBoeing - Canada DHC-8-102 · Baltimore, MDthe missing elevator stop bumper that resulted in elevator over-travel and damage to the elevator. A factor in the incident was the abrupt release of the elevator control lock in windy conditions.Mar 12, 2000 · N838EX · Minor damageNTSB DEN00LA057Accident · No injuriesLimited investigationFinal reportLearjet 60 · Jackson, WYThe pilot not following the airplane manufacturer's recommended landing procedures for a contaminated runway by landing with a tailwind. Factors were the pilot's inadvertent deactivation of the anti-skid protection, the ice contaminated runway, and the snow…Mar 12, 2000 · N240FX · Substantial damageNTSB DEN00LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Belen, NMA loss of engine power due to low cylinder compression from an open exhaust valve, and the pilot's failure to lean the fuel mixture.Mar 12, 2000 · N4069Z · Substantial damageNTSB SEA00LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Townsend, WAThe pilot's failure to adequately compensate for changing wind conditions during the landing roll in a tailwheel-equipped aircraft. Factors include a variable, shifting wind that changed from a quartering headwind to a quartering tailwind just prior to the…Mar 11, 2000 · N4994A · Substantial damageNTSB LAX00LA129Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Diego, CAThe pilot's selection of an inadequate takeoff area which precluded his ability to remain in ground effect until entering translational lift and resulted in his failure to maintain main rotor rpm.Mar 11, 2000 · N7078B · Substantial damageNTSB LAX00FA126Accident · 1 fatalField investigationFinal reportCessna 182Q · Fallbrook, CAthe loss of engine power resulting from fuel starvation due to the pilot's inadequate pre-flight inspection, inadequate performance of the pre-takeoff checklist, and failure to ensure that the fuel selector was properly positioned prior to takeoff. Also…Mar 11, 2000 · N95996 · Substantial damageNTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.Mar 11, 2000 · N8435M · Substantial damageNTSB CHI00LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Neenah, WIthe pilot's inability to flare the airplane during landing and the subsequent loss of directional control due to restricted movement of the control stick. The control stick movement was restricted by the rear seat cushion which was not secured to the…Mar 11, 2000 · N150AM · Substantial damageNTSB MIA00LA214Accident · No injuriesLimited investigationFinal reportCessna 172L · Beaufort, NCThe failure of the pilot to initiate a go-around after the airplane began to porpoise, resulting in a hard landing and structural damage to the airplane.Mar 10, 2000 · N3875Q · Substantial damageNTSB MIA00LA108Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Athens, GAThe flight attendant's failure to seat and belt herself during an inflight encounter with turbulence in clouds resulting in her losing foothold and falling against a passenger seat, sustaining a fractured ankle.Mar 10, 2000 · N636AS · No damageNTSB LAX00FA123Accident · Serious injuriesField investigationFinal reportBoeing 369D · Rough And Ready, CAa loss of engine power due to oil starvation. The oil starvation was due to the seizure and failure of the turbine element oil pump shaft, which was caused by debris from a failed bearing seizing the pump. A factor in the accident was the lack of a suitable…Mar 10, 2000 · N8351F · Substantial damageNTSB FTW00LA095Accident · No injuriesLimited investigationFinal reportBeech 65-B80 · Midland, TXThe separation of the right main landing gear tire tread which resulted in damage to the right main landing gear mounting structure.Mar 10, 2000 · N8071R · Substantial damageNTSB FTW00LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe failure of the pilot to refuel the airplane which resulted in fuel exhaustion. Factors were the pilot's poor preflight planning, failure to lean the mixture in accordance with the POH, and lack of suitable terrain for the forced landing.Mar 10, 2000 · N68333 · Substantial damageNTSB FTW00FA091Accident · 4 fatalField investigationFinal reportEurocopter BO105S-CBS-5 · Dalhart, TXThe pilot's failure to maintain control of the helicopter as a result of his continued flight into known adverse weather conditions. Factors were the dark night light condition, fog, low ceiling, and the pilot's lack of total instrument flight time.Mar 10, 2000 · N335T · DestroyedNTSB CHI00LA089Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MIthe pilot's decision to fly into known adverse weather conditions which included icing and his inability to maintain aircraft control and a proper glidepath during the approach. Factors associated with the accident were the icing weather conditions and the…Mar 10, 2000 · N311JR · Substantial damageNTSB ANC00LA035Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Delta Junction, AKThe disintegration of the number two piston. A factor in this accident was the subsequent metal fouling of the spark plugs, which resulted in total loss of engine power.Mar 10, 2000 · N75703 · Substantial damageNTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…Mar 9, 2000 · N79960 · 2 aircraft · DestroyedNTSB LAX00LA118Accident · Serious injuriesLimited investigationFinal reportArrow OH-58A · Calipatria, CAThe pilot's inadequate checklist procedure prior to departure, which did not verify the fuel selector was in the proper position for flight, and the pilot's failure to maintain adequate main rotor speed for an autorotative landing.Mar 8, 2000 · N39FA · Substantial damageNTSB IAD00WA029Accident · 2 fatalForeign investigationSikorsky S-76A · Kakap, Isle of ManMar 8, 2000 · PKPUC · DestroyedNTSB CHI00WA088Accident · 2 fatalForeign investigationHughes 269C · Tysford, United KingdomMar 8, 2000 · GZAPS · DestroyedNTSB NYC00LA091Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Pawling, NYLoss of engine power for undetermined reasons.Mar 7, 2000 · N474HH · Substantial damageNTSB NYC00LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Conesus, NYThe contamination of the aircraft's fuel. Contributing factors were the pilot's failure to maintain adequate altitude and his diversion of attention during the base turn, dark night conditions, and the tree.Mar 7, 2000 · N9040D · DestroyedNTSB LAX00LA120Accident · No injuriesLimited investigationFinal reportCessna 150E · Reedley, CAA loose seat latch which permitted the seat to move aft to a position where the pilot could no longer reach the controls.Mar 7, 2000 · N6194T · Substantial damageNTSB LAX00LA119Accident · No injuriesLimited investigationFinal reportStearman A-75 · Imperial, CAThe failure of the pilot-in-command to maintain directional control of the aircraft during landing roll.Mar 7, 2000 · N56760 · Substantial damageNTSB LAX00LA116Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Wasco, CAThe pilot's failure to use carburetor heat, which resulted in a loss of engine power. Factors included the ambient carburetor icing conditions and the lack of suitable terrain for the forced landing.Mar 7, 2000 · N1354X · Substantial damageNTSB LAX00LA115Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Incline Village, NVThe pilot's inadvertent landing on water with the wheels of the amphibious float plane extended.Mar 7, 2000 · N4021Y · Substantial damage