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 DEN07CA104Accident · No injuriesData collectionFinal reportBeech B36TC · Hudson, COThe pilot's improper in-flight decision, and his failure to maintain proper aircraft control during takeoff resulting in an inadvertent stall and the subsequent impact with the runway and terrain.NTSB CHI07LA174Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T15 · Stuttgart, ARThe loss of engine power for undetermined reasons during an aerial application flight and the unsuitable landing area encountered by the pilot during the subsequent forced landing. An additional cause was the low altitude of an aerial application operation.NTSB CHI07LA173Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Fergus Falls, MNThe propeller blade failure during climb due to a fatigue crack. The oil leak that obstructed the pilot's vision was a factor in the accident.NTSB CHI07CA175Accident · Minor injuriesData collectionFinal reportLuscombe 8A · London, OHThe pilot's failure to maintain directional control of the airplane and the pilot's inadequate compensation for the crosswind which resulted in a ground loop and subsequent collision with a taxiway sign. Factors contributing to the accident include the…NTSB SEA07LA173Accident · Minor injuriesLimited investigationFinal reportHalsted Flightstar Pioneer · Nampa, IDThe failure (fracture) of the crankshaft of the non-certificated two-cycle engine during cruise flight. Factors include a ditch running through the field in which the pilot executed his engine-out forced landing.NTSB SEA07LA172Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Oceanside, CAThe improper installation of the propeller governor (gasket) by maintenance personnel, which resulted in a oil exhaustion induced total loss of engine power. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX07CA192Accident · No injuriesData collectionFinal reportWaco UPF-7 · Reno, NVThe pilot's failure to maintain directional control.NTSB DFW07WA141Accident · 1 fatalForeign investigationCessna 337G · Moixent, SpainNTSB DFW07CA139Accident · No injuriesData collectionFinal reportMooney M-20E · Van, TXThe pilot's failure to maintain directional control during the takeoff run.NTSB CHI07LA205Accident · No injuriesLimited investigationFinal reportHarpster Hawk Aero Tandem · Southern Pines, NCThe loss of engine power during cruise due to the piston seizure for undetermined reasons and the unsuitable terrain the pilot encountered during the forced landing. A factor was the rising terrain of the mound that the airplane impacted.NTSB CHI07CA172Accident · No injuriesData collectionFinal reportCessna 195 · Battle Creek, MIThe pilot's failure to maintain directional control of the aircraft during the landing roll which resulted in a ground loop.NTSB ATL07LA092Accident · No injuriesLimited investigationFinal reportCessna 172 · Brinson, GAA partial loss of engine power due to a blocked carburetor jet.NTSB ANC07FA051Accident · Serious injuriesField investigationFinal reportCessna 206 · Homer, AKA loss of engine power due to fuel starvation from the pilot's improper fuel selector positioning, and her failure to maintain adequate airspeed to preclude a stall. Contributing to the accident was an inadvertent stall.NTSB SEA07LA160Accident · No injuriesLimited investigationFinal reportCessna 182D · Phoenix, AZThe loss of engine power due to the intake manifold disconnection to the engine's cylinders on the left side.NTSB SEA07CA171Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Park City, UTThe pilot's failure to maintain rotor RPM during hover taxi. A contributing factor was the high density altitude weather condition.NTSB SEA07CA167Accident · No injuriesData collectionFinal reportRallison Rotorway 162F · Logan, UTThe total loss of engine power due to the pilot inadvertently deactivating the rotor drive clutch assembly. A contributing factor was the downhill terrain condition where he landed, which exceeded the slope limitations of the helicopter.NTSB NYC07LA144Accident · No injuriesLimited investigationFinal reportBeech T-34A · Maxton, NCA total loss of engine power for undetermined reasons.NTSB NYC07CA141Accident · No injuriesData collectionFinal reportPiper PA31-310 · Marietta, PAThe pilot's failure to obtain the proper touchdown point, which resulted in an undershoot.NTSB MIA07WA113Accident · No injuriesForeign investigationBeech 1900D · Marlborough, New ZealandNTSB DFW07LA144Accident · Serious injuriesLimited investigationFinal reportFrew Zodiac 601XL · Oxford, MSThe loss of engine power for undetermined reasons.NTSB ATL07CA091Accident · No injuriesData collectionFinal reportBeech C-23 · Plainville, CTThe pilot's improper use of rudder and brakes on landing roll out resulting in a loss of directional control, and collapse of the main landing gear.NTSB ANC07CA049Accident · No injuriesData collectionFinal reportBritten-Norman BN2A26 · Egegik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in structural damage during the landing roll when the airplane encountered soft sand.NTSB SEA07LA163Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Tonopah, NVThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall during the takeoff initial climb. The pilot's diverted attention to an open door, high density altitude, and wind gusts were contributing factors.NTSB SEA07CA164Accident · Minor injuriesData collectionFinal reportCessna 180H · Nampa, IDThe pilot's failure to stop for additional fuel, which resulted in a loss of engine power due to fuel exhaustion.NTSB OPS07IA005Incident · No injuriesIncident investigationFinal reportPiaggio Industrie P180 · Teterboro, NJThe TEB local controller's failure to ensure separation between two aircraft departing intersecting runways.NTSB NYC07LA140Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Washington, NCA loss of engine power for undetermined reasons. Contributing to the accident was the proximity of trees.NTSB DEN07CA109Accident · No injuriesData collectionFinal reportBecerra Avid Flyer Mark IV · Crowheart, WYA partial blockage of the fuel filter, causing fuel starvation. A contributing factor was the rough terrain.NTSB CHI07LA170Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Lansing, ILThe loss of engine power during takeoff-initial climb due to a bent exhaust valve and fouled spark plugs.NTSB SEA07CA175Accident · No injuriesData collectionFinal reportBurkhart Grob G102 Std Astir III · Wickenburg, AZThe pilot's inadequate compensation for wind conditions which resulted in an inflight collision with a cactus tree while landing. The loss of thermal lift, tailwind, gusts, and tree were contributing factors to the accident.NTSB SEA07CA162Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Nimbus-3DM · Minden, NVThe flight's encounter with severe downdrafts during cruise flight. Contributing factors were the pilot's inadvertent selection of unsuitable terrain with hidden obstructions.NTSB SEA07CA161Accident · No injuriesData collectionFinal reportCessna 150J · Honolulu, HIThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for a forced landing.NTSB NYC07LA143Accident · Serious injuriesLimited investigationFinal reportNorthwing Design Apache Quest · Springfield, VTThe non-certificated pilot's failure to maintain aircraft control, due to the installation of an alternate wing design.NTSB LAX07LA195Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORThe pilot's failure to maintain directional control during the landing roll.NTSB LAX07LA148Accident · 2 fatalLimited investigationFinal reportHill Europa XS · Livermore, CAthe loss of engine power for an undetermined reason during the initial climb, and the pilot's failure to maintain adequate airspeed while attempting a return to runway maneuver, which resulted in a stall/spin.NTSB DFW07CA136Accident · No injuriesData collectionFinal reportSandall Evan R RV8 · Wilsonville, ALThe pilot's failure to maintain directional control while landing.NTSB DEN07FA100Accident · 1 fatalField investigationFinal reportBeech 58 · Placitas, NMthe failure of the pilot to maintain adequate terrain separation, for undetermined reasons, which resulted in controlled flight into terrain. A contributing factor was the mountainous terrain.NTSB DCA07WA049Accident · 6 fatalForeign investigationCessna U206F · Chelinda, MalawiNTSB SEA07LA158Accident · 3 fatalLimited investigationFinal reportShepard Lancair Propjet · Portland, ORThe loss of airplane control during climb for an undetermined reason.NTSB SEA07CA159Accident · Serious injuriesData collectionFinal reportNelson Murphy SR3500 Moose · Roche Harbor, WAThe jamming of the left brake during landing. A factor was the kit manufacturer's design of the brake system.NTSB DFW07WA137Accident · 2 fatalForeign investigationCessna 182 · San Luis Gonzag, MexicoNTSB CHI07CA171Accident · No injuriesData collectionFinal reportLuscombe 8A · Columbia, ILThe pilot's failure to maintain directional control of the airplane, causing a ground loop, subsequent runway excursion, and left main gear collapse. Factors in the accident include the ground loop encountered and the depression.NTSB CHI07CA169Accident · Minor injuriesData collectionFinal reportCessna 150H · Bellaire, MIA loss of engine power for undetermined reasons. A factor in the accident was the deer fence.NTSB ATL07CA093Accident · No injuriesData collectionFinal reportCessna 172S · Batavia, NYThe student pilot's failure to flare the airplane during landing resulting in a hard landing.NTSB ANC07CA050Accident · Minor injuriesData collectionFinal reportCessna 206 · Seldovia, AKThe pilot's inadequate compensation for wind conditions during the final landing approach, which resulted in an in-flight collision with trees. A factor associated with the accident was turbulence.NTSB SEA07FA165Accident · 1 fatalField investigationFinal reportCessna 172 · Yellow Pine, IDThe pilot's selection of the wrong routing through mountainous terrain and his failure to maintain adequate terrain clearance.NTSB SEA07CA157Accident · Minor injuriesData collectionFinal reportCessna 210M · Hailey, IDThe pilot's failure to maintain directional control of the airplane during the landing roll. Wind gusts and a quartering tailwind were factors.NTSB ATL07LA089Accident · 1 fatalLimited investigationFinal reportGordon R Smith Sea Rey · Port St. Joe, FLThe pilot's failure to maintain a visual lookout and his improper decision to conduct a low altitude maneuver.NTSB NYC07CA137Accident · Minor injuriesData collectionFinal reportPiper PA-28RT-201 · Tinicum, PAThe instrument-rated pilot's failure to maintain runway alignment by instruments after encountering fog during the initial climb. A factor was the foggy weather conditions.NTSB LAX07IA191Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZAn out of rig/jammed door. Contributing to the incident was the operator's inadequate maintenance program and the airframe manufacturer's inadequate response to the issue.NTSB DFW07WA135Accident · 2 fatalForeign investigationBell 212 · Guipuzcoa, Spain