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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX92LA235Accident · No injuriesLimited investigationFinal reportMcquen Glassair III · Casa Grande, AZFuel starvation due to the pilot's misreading of a newly installed fuel selector panel with placards and a position pointer which were confusing. Factors in the accident were the confusing nature of the fuel panel and placard design and the school bus which…NTSB FTW92LA128Accident · No injuriesLimited investigationFinal reportForney F-1 · Mason, TXThe pilot's delay in proceeding to a suitable alternate when his fuel state became questionable and his subsequent loss of control during the off airport precautionary landing. A factor was the gusty wind conditions on landing.NTSB DEN92FA052Accident · Serious injuriesField investigationFinal reportCessna 182 · Frederick, COThe pilot and operator attempting to operate the aircraft over maximum gross weight.NTSB CHI92LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Greenbay, WIA fractured rod end bolt which resulted in an unsteerable nosewheel.NTSB CHI92LA144Accident · No injuriesLimited investigationFinal reportErcoupe 415-E · Berlin, WIThe pilot's inadequate compensation for the crosswind during the takeoff roll.NTSB CHI92LA143Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Ionia, MIThe pilot-in-command's improper preflight and decision to close the glider's canopy at low altitude.NTSB CHI92FA145Accident · 3 fatalField investigationFinal reportPiper PA-18 · Arnold, NEThe pilot's failure to maintain airspeed. Factors in the accident were improper adjustment of the carburetor float level by an unknown person, and the pilot's disregarding weight-and-balance.NTSB CHI92FA142Accident · 2 fatalField investigationFinal reportTaylorcraft F19 · Harvard, ILThe pilot's failure to maintain control of the aircraft during the initial climb out. A related factor is the pilot's lack of recent experience.NTSB BFO92LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Warren, VTThe pilot's failure to select a safe altitude for flight in mountainous terrain. The downdraft was a factor.NTSB BFO92FA058Accident · 3 fatalField investigationFinal reportCessna 177 · Lusby, MDA failure of the carburetor resulting in a loss of engine power.NTSB ATL92LA098Accident · Minor injuriesLimited investigationFinal reportAvid Flyer Heavy Hauler · Wendell, NCThe improper installation of the forward spark plug by the owner/pilot, which resulted in a loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB ATL92LA097Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Cartersville, GAThe pilot's failure to operate the flight controls properly during the takeoff attempt and the pilot's planning decision during rollout.NTSB ANC92LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Twin Hills, AKDirectional control was not maintained. A factor to the accident was: a bird.NTSB LAX92LA208Accident · No injuriesLimited investigationFinal reportCorbus/Winters BD-5B · Fresno, CAThe total loss of engine power during initial climb due to a fracture and failure of the engine starter ring gear. A contributing factor which was related to the mechanical failure was the airplane owner's inadequate maintenance.NTSB LAX92LA207Accident · 1 fatalLimited investigationFinal reportLawrence H. Macey Quicksilver GT500 · Perris, CAThe pilot's failure to maintain control of his airplane for undetermined reasons.NTSB FTW92FA127Accident · 2 fatalField investigationFinal reportNanchang YAK-18A · Richmond, TXInadvertent stall. Factors were the pilot's ostentatious display and the low altitude.NTSB CHI92DCG01Accident · Serious injuriesFinal reportCedric Lewellen Soneria II · Bolivar, MOThe pilot's improper preflight planning/preparation.NTSB ATL92LA099Accident · 1 fatalLimited investigationFinal reportCessna 150G · Samburg, TNThe pilot's poor judgement in that he attempted aerobatic maneuvers at an altitude that was too low to recover from the maneuver.NTSB ANC92LA071Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Chitina, AKThe pilot's failure to maintain proper alignment with the landing area. Contributing factors were the gusty wind and the trees.NTSB ANC92LA068Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai, AKThe pilot's improper use of carburetor heat which resulted in loss of engine power due to carburetor ice.NTSB ANC92FA069Accident · No injuriesField investigationFinal reportCessna 172 · Ruth Glacier, AKThe failure of the pilots of both airplanes to maintain an adequate visual lookout. Factors which contributed to the accident was the failure of the pilot of the CE-172 to become aware of and to use the listed frequency for inter aircraft communications, and…NTSB SEA92LA093Accident · No injuriesLimited investigationFinal reportAviat A-1 · Arco, IDThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.NTSB LAX92FA206Accident · 1 fatalField investigationFinal reportRobinson R-22B · Anaheim, CAThe total loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate rotor RPM during the autorotation.NTSB CHI92LA146Accident · No injuriesLimited investigationFinal reportCessna 150F · Eldon, MOA binding exhaust valve resulting in a partial loss of engine power. Factors in the accident are rising terrain conditions, inadequate aircraft climb capability, and a ditch in the forced landing area.NTSB BFO92LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Falmouth, KYThe pilot misjudged the airplane's altitude and distance in reference to the runway. Contributing to the accident was the fuel system leak.NTSB ANC92LA072Accident · No injuriesLimited investigationFinal reportCessna C-180J · Seldovia, AKThe improper in-flt planning/decision by the pilot to land on a short gravel airstrip in tailwind wx conditions and his failure to correct a gnd loop/swerve during landing roll. Factors relating to the accident were the gusty, tailwind weather conditions.NTSB SEA92LA094Accident · No injuriesLimited investigationFinal reportFairchild 24W-40 · Toledo, WAThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. A factor contributing to the accident was crosswinds.NTSB SEA92LA092Accident · No injuriesLimited investigationFinal reportCessna 150F · Gold Beach, ORFailure of the pilot to maintain airspeed on final approach, resulting in aircraft stall, loss of control and impact with terrain. A factor relating to the accident was the lack of experience by the pilot.NTSB LAX92FA204Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Cucamonga, CAThe pilot's decision to continue VFR flight into instrument meteorological conditions. Factors in the accident were: the pilot's failure to obtain a weather briefing, the adverse weather conditions, his physical impairment due to drugs, and the mountainous…NTSB CHI92IA141Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Valentine, NEThe failure of the pilot in command to extend the landing gear and the inattentive FAA inspector (check airman). Associated factors are the inoperative landing gear warning system, the inadequate preflight inspection by the pilot and FAA inspector, and the…NTSB LAX92LA285Accident · No injuriesLimited investigationFinal reportSchweizer 1-36 · Hemet, CAThe pilot's inadvertent selection of unsuitable terrain for the precautionary landing. A factor in the accident was his failure to obtain a preflight weather briefing.NTSB LAX92LA203Accident · No injuriesLimited investigationFinal reportCessna 182K · Carefree, AZInadequate aircraft maintenance and the failure of the pilot to ensure that adequate engine oil was on board prior to departure.NTSB LAX92FA201Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Camarillo, CAThe pilot's failure to follow the published instrument missed approach procedure, and his failure to initiate a timely climb after being given a low altitude alert. Factors contributing to the accident were: the controller's failure to take positive action…NTSB CHI92DEM02Accident · No injuriesFinal reportGillespie/Pitts S1C · Freeland, MIA total failure of the rudder control cable and unavailability of rudder to control the airplane during its landing process. Factors which contributed to the accident were directional control and remedial action not being possible on behalf of the pilot.NTSB CHI92DCD04Accident · No injuriesFinal reportHiller UH-12E · Milford, IAA total loss of engine power for an undetermined reason as the helicopter was performing aerial application maneuvers.NTSB ATL92FA096Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Mt. Pleasant, TNA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the cockpit area.NTSB SEA92LA091Accident · No injuriesLimited investigationFinal reportRockwell S2R · St. John, WAThe separation of the number 1 cylinder and remedial action by the PIC not possible. A factor contributing to the accident was: rough/uneven terrain.NTSB NYC92FA090Accident · 1 fatalField investigationFinal reportBeech A36 · Southbury, CTThe failure of the pilot to monitor his fuel supply which resulted in a power loss due to fuel exhaustion and an inadvertent stall/spin as the pilot was maneuvering for a forced landing. Factors related to the accident was improper maintenance on the fuel…NTSB LAX92LA200Accident · No injuriesLimited investigationFinal reportPiper PA23-150 · Modesto, CAAn engine power loss due to fuel contamination.NTSB LAX92FA202Accident · 1 fatalField investigationFinal reportCessna 152 · Pinyon Pines, CAThe pilot's failure to maintain adequate altitude while maneuvering in mountainous terrain which resulted in getting trapped in a box canyon, resulting in a stall due to inadequate airspeed. Factors which contributed to the accident were: the pilot's decision…NTSB FTW92LA126Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Benton, ARThe pilot's improper recovery from a bounced landing and his improper compensation for crosswind. A factor was the crosswind.NTSB ATL92LA095Accident · No injuriesLimited investigationFinal reportCessna 180B · Jacksonville, NCThe pilot's failure to ensure an adequate supply of fuel for the planned flight; which resulted in fuel exhaustion. A factor was the high vegetation in the forced landing field.NTSB SEA92LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Parkdale, ORThe pilot's failure to use the proper touchdown point for landing. A factor relating to the accident was the soft dirt runway surface.NTSB MIA92LA122Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Boynton Beach, FLPremature extension of the spoilers by the pilot during approach to land. Contributing to the accident was his lack of total experience in the type of aircraft and in-flight encounter with a downdraft.NTSB LAX92LA199Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Sun Valley, CA1) Fuel exhaustion due to improper preflight planning by the CFI and his failure to refuel the aircraft prior to departure on the accident flight, and 2) the cfi's misjudgement of the landing flare timing during the auto rotation.NTSB LAX92LA198Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lake Havasu, AZThe failure of the pilot to maintain directional control of the aircraft during the landing touch down.NTSB DEN92IA050Incident · 1 fatalIncident investigationFinal reportBoeing 757-222 · Denver, COThe captain suffered a fatal heart attack.NTSB ANC92LA066Accident · No injuriesLimited investigationFinal reportCessna C-170B · Talkeetna, AKLoss of control on landing roll due to the pilot's failure to maintain proper alignment, resulting in collision with terrain during an uncontrolled ground loop/swerve. A factor relating to the accident was the crosswind weather conditions.NTSB ANC92FAMS2Accident · 5 fatalMissing aircraftFinal reportCessna 340 · Yakutat, AKMissing aircraft due to undetermined causes.NTSB SEA92LA089Accident · 1 fatalLimited investigationFinal reportPilatus B-4 PC 11A · Wenatchee, WAFailure by the pilot to maintain airspeed, resulting in aircraft stall.