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 ATL90LA138Accident · Minor injuriesLimited investigationFinal reportBell BH-47G · Seagrove, NCFailure of a number four connecting rod bolt for an undetermined reason.Jun 28, 1990 · N3081G · Substantial damageNTSB ANC90LA100Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Olson Creek, AKThe pilot's selection of unsuitable terrain.Jun 28, 1990 · N2667Z · Substantial damageNTSB SEA90LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Reno, NVThe pilot's use of an inappropriate runway. The gusty tailwind and the pilot's lack of experience were factors related to the accident.Jun 27, 1990 · N64845 · Substantial damageNTSB MKC90LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARFailure of the engine driven blower assembly. A factor was the lack of suitable terrain for the forced landing.Jun 27, 1990 · N5203 · Substantial damageNTSB MIA90LA146Accident · No injuriesLimited investigationFinal reportAyres S-2R · Fort Pierce, FLEngine failure due to failure of the engine driven fuel pump shaft due to undetermined reasons.Jun 27, 1990 · N4909X · DestroyedNTSB DEN90LA145Accident · Minor injuriesLimited investigationFinal reportGrumman AA5B · Monte Vista, COThe pilot's premature rotation and liftoff.Jun 27, 1990 · N28421 · DestroyedNTSB ANC90LA098Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Caribou Lake, AKA power loss caused by the failure of a piston cylinder.Jun 27, 1990 · N5147G · Substantial damageNTSB ANC90FA097Accident · Serious injuriesField investigationFinal reportCessna 206 · Fairbanks, AKThe failure of the wristpin caused the separation of the connecting rod from the piston and subsequent seizure of the engine. A factor was unavailability of a suitable forced landing area.Jun 27, 1990 · N7560G · Substantial damageNTSB MKC90LA138Accident · No injuriesLimited investigationFinal reportHiller 12-E · Watson, MNPilot misjudged his flare and collided with the terrain.Jun 26, 1990 · N62397 · Substantial damageNTSB MKC90LA137Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Goddard, KSFuel starvation due to a loose fuel strainer screen. A factor related to this accident was lack of suitable terrain for a forced landing.Jun 26, 1990 · N1655C · Substantial damageNTSB MIA90FA145Accident · 2 fatalField investigationFinal reportPiper PA-31 · Panama City, FLA loss of power on both engines during takeoff as a result of inadequate maintenance. In addition, the pilot failed to abort the takeoff.Jun 26, 1990 · N18PA · DestroyedNTSB LAX90LA231Accident · No injuriesLimited investigationFinal reportCessna 152 · Fillmore, CAThe inadvertent engagement of the starter during flight for undetermined reasons. >Jun 26, 1990 · N528CA · Substantial damageNTSB FTW90FA125Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Dallas, TXThe initial partial loss of engine power, followed by the total loss of engine power and the striking of a hidden set of transmission wires.Jun 26, 1990 · N6608V · DestroyedNTSB DEN90LA142Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Durango, COA pilot induced stall. A factor was the pilot's lack of experience.Jun 26, 1990 · N3667T · Substantial damageNTSB CHI90MA162Accident · 1 fatalMajor investigationFinal reportPiper PA-46-310P · Lakeville, MIThe pilot's failure to use the airplane's ice protection equipment, which resulted in a performance loss due to induction icing, propeller icing, or both, while flying in convective instrument meteorological conditions (IMC) at and above the freezing level.…Jun 26, 1990 · N315RC · DestroyedNTSB CHI90LA163Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Savoy, ILThe loss of engine power for undetermined reasons and the inadvertent stall during the forced landing.Jun 26, 1990 · N35703 · DestroyedNTSB CHI90DEE07Accident · Minor injuriesFinal reportSchweizer G-164B · Deer Grove, ILThe pilot's inadequate visual lookout, resulting in collision with a power line.Jun 26, 1990 · N8483K · Substantial damageNTSB MKC90LA141Accident · No injuriesLimited investigationFinal reportBeech B-60 · Hutchinson, KSEngine failure for undetermined reasons. A factor in the accident was that there was no suitable terrain in which to make a forced landing.Jun 25, 1990 · N725DJ · Substantial damageNTSB MKC90LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Tecumseh, NEExcessive taxi speed and directional control not maintained by the pilot in command.Jun 25, 1990 · N2873K · Substantial damageNTSB MIA90IA144Incident · No injuriesIncident investigationFinal reportCessna 210L · Fort Lauderdale, FLIncorrect placement of the retaining ring in the left main landing gear door actuator by the mechanic resulting in the loss of hydraulic fluid. This prevented the gear from extending resulting in the gear up landing.Jun 25, 1990 · N732BL · Minor damageNTSB LAX90DUG07Accident · Serious injuriesFinal reportSpark/Acroduster SA/750 · Redlands, CAThe pilots failure to maintain a speed above a stall after experiencing a loss of engine power. Contributing to the accident was the pilot's miscalculation of the fuel supply.Jun 25, 1990 · N10WS · Substantial damageNTSB ANC90FA101Accident · 5 fatalField investigationFinal reportCessna 207A · Aialak Bay, AKThe pilot-in-command's attempt to fly under visual flight rules while in instrument meteorological conditions. Contributing factors to the accident were the low ceiling and surrounding mountainous terrain.Jun 25, 1990 · N9985M · DestroyedNTSB SEA90LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Hitchcock, WAThe pilot's loss of control of the airplane during final approach for landing. Sunglare was a factor related to the accident.Jun 24, 1990 · N13227 · Substantial damageNTSB SEA90LA111Accident · Minor injuriesLimited investigationFinal reportCallair A-3 · Burley, IDAn encounter with meteorological conditions that exceeded the aircraft's ability to climb or maintain level flight. The high density altitude and lack of suitable terrain were factors related to the accident.Jun 24, 1990 · N2911V · Substantial damageNTSB NYC90LA138Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lancaster, PAThe pilot's selection of an unsuitable landing site. Contributing to the accident was the pilots decision to land in a field with insufficient space available.Jun 24, 1990 · N6442G · Substantial damageNTSB NYC90LA137Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · West Milford, NJThe failure of the pilot in command to attain the proper touchdown point while making a forced landing following loss of engine power due to fuel exhaustion.Jun 24, 1990 · N3674Q · Substantial damageNTSB LAX90FA229Accident · No injuriesField investigationFinal reportPiper PA-24-260 · Corona, CASabotage wherein unknown person(s) put sand in the airplane's fuel tank.Jun 24, 1990 · N9302P · Substantial damageNTSB FTW90LA123Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Mc Allen, TXLoss of engine power for undetermined reasons. The concrete canal that he impacted was a factor.Jun 24, 1990 · N1568U · Substantial damageNTSB DEN90LA144Accident · Serious injuriesLimited investigationFinal reportCessna C-152 · Golden, COThe pilot's disregard for airplane performance data. Contributing to the accident were high density altitude and the fact that airplane climb performance capability was exceeded.Jun 24, 1990 · N757KL · Substantial damageNTSB DEN90LA143Accident · No injuriesLimited investigationFinal reportCessna 150 · Bountiful, UTPower loss due to fuel exhaustion. A factor was the pilot's failure to refuel.Jun 24, 1990 · N7885F · Substantial damageNTSB DEN90LA141Accident · No injuriesLimited investigationFinal reportBeech 23 · Wheatland, WYPermature liftoff.Jun 24, 1990 · N2310J · Substantial damageNTSB CHI90FA161Accident · 1 fatalField investigationFinal reportCessna 152 · Hagerstown, INThe pilot's failure to use all available runway and failure to abort the takeoff.Jun 24, 1990 · N4840B · DestroyedNTSB CHI90DEE06Accident · No injuriesFinal reportPiper PA 28 140 · Savanna, ILThe pilot's misjudgement of the airplane's fuel supply, resulting in fuel exhaustion.Jun 24, 1990 · N5744F · Substantial damageNTSB ATL90LA137Accident · No injuriesLimited investigationFinal reportCessna 150L · Blountville, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.Jun 24, 1990 · N1408Q · Substantial damageNTSB ANC90LA095Accident · No injuriesLimited investigationFinal reportBell B-47G2A · Dutch Harbor, AKThe pilot in commands continued VFR flight into IMC conditions and his failure to maintain altitude while manuevering to avoid terrain.Jun 24, 1990 · N8495E · DestroyedNTSB SEA90LA110Accident · No injuriesLimited investigationFinal reportCessna 340A · Priest River, IDThe pilot's misjudgement of distance and altitude and his failure to maintain an adequate airspeed during the landing approach.Jun 23, 1990 · N2703U · Substantial damageNTSB MKC90LA140Accident · No injuriesLimited investigationFinal reportPiper J-3 · Clarksville, ARFailure of the pilot to maintain flying speed.Jun 23, 1990 · N38348 · Substantial damageNTSB MIA90LA143Accident · No injuriesLimited investigationFinal reportCessna 150M · Rockledge, FLThe pilots failure to raise the flaps as required during the go-around and failure to place the carburetor heat in the cold position.Jun 23, 1990 · N66453 · Substantial damageNTSB LAX90LA228Accident · No injuriesLimited investigationFinal reportNavion A · Big Bear, CAThe failure of the pilot to adequately compensate for the cross wind on his approach.Jun 23, 1990 · N8081E · Substantial damageNTSB LAX90LA227Accident · No injuriesLimited investigationFinal reportRobinson R22A · Pinon Hills, CAThe pilot's failure to maintain adequate rotor RPM during an attempted takeoff. A contributing factor was the high density altitude.Jun 23, 1990 · N84378 · Substantial damageNTSB LAX90FA230Accident · No injuriesField investigationFinal reportHughes 369D · Hanapepe, HIFailure of pilot of the photographing helicopter to maintain clearance and avoid collision.Jun 23, 1990 · N8605F · 2 aircraft · Substantial damageNTSB LAX90DVG10Accident · Serious injuriesFinal reportChilds 360 · Davis, CAAn engine failure due to fuel exhaustion after the pilot failed to properly secure the stopper to the fuel tank.Jun 23, 1990 · N360GC · DestroyedNTSB FTW90LA124Accident · No injuriesLimited investigationFinal reportCessna 150L · Tomball, TXStudent pilot's failure to maintain directional control and proper alignment with timely manner after a bounced landing. A factor in the accident was the presence of a right quartering headwind.Jun 23, 1990 · N1792Q · Substantial damageNTSB FTW90LA122Accident · Serious injuriesLimited investigationFinal reportPiccard P-80 · Peaster, TXAn excessive rate of descent during the approach.Jun 23, 1990 · N99US · DestroyedNTSB FTW90DQG03Accident · 1 fatalFinal reportNorth American P-51D · Abilene, TXFailure of the pilot to maintain adequate airspeed, while maneuvering after a low pass, which resulted in an inadvertent stall. The high density altitude was a related factor.Jun 23, 1990 · N12700 · DestroyedNTSB DEN90DTG02Accident · 1 fatalFinal reportEugene N. Rausch RV-4 · Erie, NDAn inadvertent stall.Jun 23, 1990 · N319ER · DestroyedNTSB BFO90LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Clinton, MDThe student pilot's failure to maintain directional control of the aircraft and his improper use of the throttle control. Contributing to the accident was the student's lack of total experience.Jun 23, 1990 · N48741 · Substantial damageNTSB ANC90LA096Accident · No injuriesLimited investigationFinal reportShort Brothers SH-7 · Kako Mine Strip, AKThe pilot-in-command's failure to maintain control of the airplane through the touchdown and landing phase.Jun 23, 1990 · N50GA · Substantial damageNTSB SEA90LA109Accident · No injuriesLimited investigationFinal reportMaule M-5 · Riverside, ORThe pilot's selection of unsuitable terrain for a landing site and his inadequate compensation for the wind condition. Factors related to the accident were: the tailwind and the ditch.Jun 22, 1990 · N9058E · Substantial damageNTSB SEA90LA108Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dayton, WALoss of engine power for an undetermined reason.Jun 22, 1990 · N4855R · Substantial damage