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 MKC90LA134Accident · No injuriesLimited investigationFinal reportWeatherly 201-B · Stuttgart, ARFuel exhaustion induced power loss caused by the pilot's failure to refuel the airplane.NTSB MKC90LA132Accident · No injuriesLimited investigationFinal reportPiper PA-36-400 · Altheimer, ARDirectional control was not maintained by the pilot in command. Contributing factors were landing with a tailwind. Compensation for wind conditions not considered and selection of the wrong runway.NTSB MKC90LA131Accident · Minor injuriesLimited investigationFinal reportEugene M. Veras Polliwagon 150 · St. Charles, MOThe flight control system-stick was loose resulting in an stall.NTSB MKC90FA130Accident · 3 fatalField investigationFinal reportBell 47G-3B1 · Cedar Rapids, IAThe failure of the pilot to maintain control of the helicopter during maneuvering flight. Darkness and the pilot's manner of flying the aircraft (ostentatious display) were considered to be related factors.NTSB MKC90DCJ01Accident · 1 fatalFinal reportK. W. Jeffers Varieze · Brainard, NEPilot used poor judgement in attempting aerobatics with inadequate altitude which resulted in loss of aircraft control. Contributing factors were a low pass performed, over confidence in personal ability and ostentatious display by the PIC.NTSB LAX90LA226Accident · No injuriesLimited investigationFinal reportCessna 182A · Georgetown, CAThe pilot's failure to maintain directional control during landing. Contributing factors were the pilot's improper compensation for the gusty wind conditions, and her improper bounced landing recovery.NTSB LAX90LA221Accident · Serious injuriesLimited investigationFinal reportGrumman G21A · Long Beach, CAThe pilot's failure to retract the landing gear resulting in an inadvertent wheels-down landing in water. In addition, a loss of elevator control was encountered due to a stress corrosion failure of an elevator control cable turnbuckle as a result of…NTSB LAX90LA220Accident · No injuriesLimited investigationFinal reportAerostar S-66A · Davis, CAThe failure of the pilot to properly manage the fuel valves to provide adequate fuel pressure to the burner.NTSB DEN90LA137Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Truth/Consequen, NMThe pilot's failure to maintain proper airspeed and obtain a proper climb rate after takeoff.NTSB CHI90LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Flint, MIA loose fuel line caused by improper installation by maintenance personnel.NTSB BFO90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chester, MDThe pilot's misidentification of a road for the runway. Factors were sunglare and the pilot's unfamiliarity with the airport, and inadequate visual lookout.NTSB ATL90LA130Accident · No injuriesLimited investigationFinal reportCessna 150 · Kinston, NCFlight crew's failure to properly preflight and plan for the intended flight by not ensuring that adequate fuel was on board prior to takeoff. The engine quit due to fuel exhaustion.NTSB ATL90FA132Accident · 1 fatalField investigationFinal reportCessna 182E · Newland, NCAttempted VFR flight into instrument meteorological conditions.NTSB SEA90LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yamhill, ORPilot did not maintain an adequate airspeed after takeoff which resulted in a loss of control and aborted takeoff. The pilot did not maintain directional control of the airplane and did not properly correct the situation before colliding with trees and a…NTSB NYC90FA130Accident · 1 fatalField investigationFinal reportConsolidated Aeronautics LA-4-200 · Danbury, CTThe inadvertent stall. A factor was the pilot's misjudgement of the landing flare.NTSB MKC90LA129Accident · No injuriesLimited investigationFinal reportRockwell S2R · Tilton, ARFailure of the engine blower(supercharger). Related to the accident was the soft/wet terrain, where the forced landing was performed.NTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.NTSB MIA90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Boca Raton, FLThe pilots failure to flare the airplane for landing resulting in the hard landing.NTSB LAX90LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Show Low, AZThe pilot improperly used the flight controls and failed to maintain directional control.NTSB LAX90DVA06Accident · No injuriesFinal reportRay Edmistonn Z-200 · Selma, CAA loss of engine power for undetermined reasons.NTSB LAX90DVA05Accident · No injuriesFinal reportVans RV-3 · Bakersfield, CAThe pilots loss of directional control after a touch and go landing in a newly acquired homebuilt aircraft. Contributing to the accident was the pilots lack of experience in this aircraft.NTSB FTW90DPA07Accident · No injuriesFinal reportAyres S2R · Mcgregor, TXThe fuel exhaustion induced power loss, which resulted from the pilot's inaccurate fuel consumption calculations.NTSB DEN90FA135Accident · 2 fatalField investigationFinal reportCessna TU206G · Challis, IDThe pilot's entry into an excessive maneuver after takeoff with insufficient altitude and airspeed to complete the maneuver, which resulted in a stall/mush into trees. Factors related to the accident were: high density altitude and trees.NTSB BFO90FA057Accident · 2 fatalField investigationFinal reportMooney M20E · Charleston, WVThe pilot's improper IFR procedures, his failure to maintain a proper glide path on the ILS approach, and his failure to initiate a missed approach at the decision height. The adverse weather was a related factor.NTSB ATL90TL#04Accident · No injuriesClass 3Final reportHughes TH-55 · Brunswick, GANTSB NYC90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Middleton, RILoss of direction control by the pilot when he came in high and fast and touched down at improper touchdown point.NTSB NYC90FA129Accident · 2 fatalField investigationFinal reportCessna 337G · Harrison, NYThe pilot's decision to continue VFR flight into IMC and his subsequent loss of control of the airplane. The weather conditions and the pilot's lack of instrument flight experience were factors in the accident.NTSB FTW90DPA06Accident · No injuriesFinal reportPiper PA-25-260 · Rosebud, TXInadvertent stall/mush. A factor was: premature rotation.NTSB CHI90DEP05Accident · No injuriesFinal reportCirrus Klappmeier Cirrus VF-30 · Baraboo, WIManufacturer's inadequate equipment design to prevent a fuel leak which resulted in an in-flight fire. A factor related to the accident was the lack of an unsuitable forced landing area.NTSB CHI90DEM04Accident · 1 fatalFinal reportVanek 300 · Vriesland, MIThe pilot's misjudgment of the altitude. A factor related to the accident was the low ceiling.NTSB SEA90LA119Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Hawthorne, NVThe pilot's selection of unsuitable terrain for landing.NTSB MKC90LA127Accident · No injuriesLimited investigationFinal reportCessna 188 · Joiner, ARPremature lift-off by the pilot in command.NTSB MIA90LA141Accident · No injuriesLimited investigationFinal reportBeech D95A · Mayaguez, PRThe pilot failed to property align the aircraft with the runway. A factor in the accident was the strong, gusty crosswind.NTSB DEN90LA134Accident · No injuriesLimited investigationFinal reportCessna A185F · Erie, COFailure of the pilot receiving instruction to choose suitable terrain for the landing. Contributing to the accident was the cfi's inadequate supervision.NTSB DEN90LA133Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Brigham City, UTThe pilot's failure to attain the proper touchdown point.NTSB CHI90LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Millersburg, OHFailure of the pilot to maintain directional control during a go-around attempt. The pilots lack of total aviation experience and his motion sickness are factors associated with the accident.NTSB ATL90LA129Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Hartford, KYImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB NYC90LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Tarentum, PAAirplane nosed over during landing rollout after the pilot failed to maintain directional control on the runway and improperly used the brakes.NTSB NYC90LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marcellus, NYFailure of the pilot-in-command to maintain airspeed after takeoff. A contributing factor was the the upslope gradient of the runway.NTSB MKC90LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fisher, ARPartial loss of engine power for an undetermined reason.NTSB ANC90FA088Accident · 2 fatalField investigationFinal reportTaylorcraft BC-12D · Fairbanks, AKThe pilot-in-command's failure to maintain adequate flying speed.NTSB SEA90LA099Accident · No injuriesLimited investigationFinal reportBriegleb BG-12B · Wenatchee, WAPilot's improper inflight planning which resulted in the aircraft undershooting the runway. Factors in the accident were the high, gusty wind conditions.NTSB SEA90LA095Accident · 1 fatalLimited investigationFinal reportGrace Long EZ · La Grande, ORLoss of engine power due to fuel contamination which resulted from the pilot's inadequate preflight inspection of the aircraft.NTSB SEA90FA100Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Pocatello, IDThe instructor pilots poor judgement in performing low altitude steep turn maneuvers resulting in an inadvertant stall at an altitude too low for recovery. Factors in the accident were the over gross weight and out-of-cg aircraft loading, and strong gusty…NTSB MKC90LA124Accident · No injuriesLimited investigationFinal reportBell B47G-5 · Shell Knob, MOVisual outlook not maintained by the pilot in command.NTSB LAX90FA219Accident · 1 fatalField investigationFinal reportAerotek Pitts S2A · Thermal, CAThe pilot's inadequate handling of the airplane during an aerobatic maneuver.NTSB CHI90LA150Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hillsboro, OHFailure of the pilot to maintain directional control during initial climb after takeoff. The pilot's lack of experience in the airplane is a factor.NTSB ATL90FA128Accident · 2 fatalField investigationFinal reportMooney M20J · Andrews, NCFailure of the pilot to maintain proper altitude/clearance over high terrain. Darkness and high terrain were related factors.NTSB ANC90LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Deshka River, AKThe pilot-in-command's failure to maintain directional control.NTSB NYC90LA126Accident · Serious injuriesLimited investigationFinal reportBarnes Firefly 8B · Cazenovia, NYThe passengers failure to comply with the pilots instructions after a hard landing was made.