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 MKC90LA134Accident · No injuriesLimited investigationFinal reportWeatherly 201-B · Stuttgart, ARFuel exhaustion induced power loss caused by the pilot's failure to refuel the airplane.Jun 16, 1990 · N1260W · Substantial damageNTSB 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.Jun 16, 1990 · N57706 · Substantial damageNTSB MKC90LA131Accident · Minor injuriesLimited investigationFinal reportEugene M. Veras Polliwagon 150 · St. Charles, MOThe flight control system-stick was loose resulting in an stall.Jun 16, 1990 · N21EV · Substantial damageNTSB 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.Jun 16, 1990 · N67223 · Substantial damageNTSB 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.Jun 16, 1990 · N3KJ · DestroyedNTSB 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.Jun 16, 1990 · N2170G · Substantial damageNTSB 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…Jun 16, 1990 · N86640 · Substantial damageNTSB 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.Jun 16, 1990 · N6307C · Substantial damageNTSB DEN90LA137Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Truth/Consequen, NMThe pilot's failure to maintain proper airspeed and obtain a proper climb rate after takeoff.Jun 16, 1990 · N94351 · Substantial damageNTSB CHI90LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Flint, MIA loose fuel line caused by improper installation by maintenance personnel.Jun 16, 1990 · N6583T · DestroyedNTSB 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.Jun 16, 1990 · N8167R · Substantial damageNTSB 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.Jun 16, 1990 · N6436K · Substantial damageNTSB ATL90FA132Accident · 1 fatalField investigationFinal reportCessna 182E · Newland, NCAttempted VFR flight into instrument meteorological conditions.Jun 16, 1990 · N9244X · DestroyedNTSB 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…Jun 15, 1990 · N9765J · Substantial damageNTSB NYC90FA130Accident · 1 fatalField investigationFinal reportConsolidated Aeronautics LA-4-200 · Danbury, CTThe inadvertent stall. A factor was the pilot's misjudgement of the landing flare.Jun 15, 1990 · N76KK · Substantial damageNTSB 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.Jun 15, 1990 · N8421V · Substantial damageNTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.Jun 15, 1990 · N3650Z · Substantial damageNTSB MIA90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Boca Raton, FLThe pilots failure to flare the airplane for landing resulting in the hard landing.Jun 15, 1990 · N3822W · Substantial damageNTSB LAX90LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Show Low, AZThe pilot improperly used the flight controls and failed to maintain directional control.Jun 15, 1990 · N8512B · Substantial damageNTSB LAX90DVA06Accident · No injuriesFinal reportRay Edmistonn Z-200 · Selma, CAA loss of engine power for undetermined reasons.Jun 15, 1990 · N10LM · Substantial damageNTSB 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.Jun 15, 1990 · N9030N · Substantial damageNTSB FTW90DPA07Accident · No injuriesFinal reportAyres S2R · Mcgregor, TXThe fuel exhaustion induced power loss, which resulted from the pilot's inaccurate fuel consumption calculations.Jun 15, 1990 · N8472V · Substantial damageNTSB 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.Jun 15, 1990 · N7582N · DestroyedNTSB 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.Jun 15, 1990 · N3260F · DestroyedNTSB ATL90TL#04Accident · No injuriesClass 3Final reportHughes TH-55 · Brunswick, GAJun 15, 1990 · N7057K · Substantial damageNTSB 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.Jun 14, 1990 · N8569N · Substantial damageNTSB 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.Jun 14, 1990 · N72476 · DestroyedNTSB FTW90DPA06Accident · No injuriesFinal reportPiper PA-25-260 · Rosebud, TXInadvertent stall/mush. A factor was: premature rotation.Jun 14, 1990 · N4843Y · Substantial damageNTSB 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.Jun 14, 1990 · N888EK · DestroyedNTSB CHI90DEM04Accident · 1 fatalFinal reportVanek 300 · Vriesland, MIThe pilot's misjudgment of the altitude. A factor related to the accident was the low ceiling.Jun 14, 1990 · N359VE · DestroyedNTSB SEA90LA119Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Hawthorne, NVThe pilot's selection of unsuitable terrain for landing.Jun 13, 1990 · N90DM · Substantial damageNTSB MKC90LA127Accident · No injuriesLimited investigationFinal reportCessna 188 · Joiner, ARPremature lift-off by the pilot in command.Jun 13, 1990 · N2059J · Substantial damageNTSB 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.Jun 13, 1990 · N744GP · Substantial damageNTSB 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.Jun 13, 1990 · N8389Q · Substantial damageNTSB DEN90LA133Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Brigham City, UTThe pilot's failure to attain the proper touchdown point.Jun 13, 1990 · N3637F · Substantial damageNTSB 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.Jun 13, 1990 · N7955U · Substantial damageNTSB 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.Jun 13, 1990 · N4760D · Substantial damageNTSB 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.Jun 12, 1990 · N4010N · Substantial damageNTSB 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.Jun 12, 1990 · N1323T · Substantial damageNTSB MKC90LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fisher, ARPartial loss of engine power for an undetermined reason.Jun 12, 1990 · N5257 · DestroyedNTSB ANC90FA088Accident · 2 fatalField investigationFinal reportTaylorcraft BC-12D · Fairbanks, AKThe pilot-in-command's failure to maintain adequate flying speed.Jun 12, 1990 · N43949 · DestroyedNTSB 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.Jun 11, 1990 · N1696 · DestroyedNTSB 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.Jun 11, 1990 · N9175Y · DestroyedNTSB 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…Jun 11, 1990 · N1877G · DestroyedNTSB MKC90LA124Accident · No injuriesLimited investigationFinal reportBell B47G-5 · Shell Knob, MOVisual outlook not maintained by the pilot in command.Jun 11, 1990 · N7089J · Substantial damageNTSB LAX90FA219Accident · 1 fatalField investigationFinal reportAerotek Pitts S2A · Thermal, CAThe pilot's inadequate handling of the airplane during an aerobatic maneuver.Jun 11, 1990 · N29MC · DestroyedNTSB 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.Jun 11, 1990 · N9836Y · Substantial damageNTSB 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.Jun 11, 1990 · N201SE · DestroyedNTSB ANC90LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Deshka River, AKThe pilot-in-command's failure to maintain directional control.Jun 11, 1990 · N7939V · Substantial damageNTSB NYC90LA126Accident · Serious injuriesLimited investigationFinal reportBarnes Firefly 8B · Cazenovia, NYThe passengers failure to comply with the pilots instructions after a hard landing was made.Jun 10, 1990 · N3702M · No damage