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 FTW99LA246Accident · No injuriesLimited investigationFinal reportCessna 170A · Brady, TXThe pilot's failure to maintain clearance from a dirt bank.Sep 3, 1999 · N3865V · Substantial damageNTSB DEN99LA159Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe pilot's failure to maintain adequate airspeed during the flare for landing/touchdown phase of flight. A factor was a ditch off the side of the runway.Sep 3, 1999 · N62740 · Substantial damageNTSB ATL99FA122Accident · 3 fatalField investigationFinal reportMooney M20J · Gainesville, GAThe pilot's failure to maintain flying speed which resulted in a stall and the subsequent collision with terrain.Sep 3, 1999 · N4072H · DestroyedNTSB ANC99FA130Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Bettles, AKThe pilot's continued flight into known adverse weather conditions. Factors in the accident were low ceilings and snow.Sep 3, 1999 · N9166K · DestroyedNTSB NYC99LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Greenville, METhe pilot in command's inattentive management of the fuel supply.Sep 2, 1999 · N2584P · Substantial damageNTSB LAX99LA291Accident · Serious injuriesLimited investigationFinal reportBoeing 737-322 · Santa Barbara, CAThe flight's encounter with wake vortices from a preceding heavy aircraft.Sep 2, 1999 · N371UA · Minor damageNTSB LAX99FA294Accident · 1 fatalField investigationFinal reportMooney M20D · Bear Valley, CAThe pilot's in-flight loss of control for undetermined reasons.Sep 2, 1999 · N6831U · DestroyedNTSB IAD99LA064Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Nantucket, MAthe pilot's inadequate recovery from a bounced landing which resulted in a hard landing and the fracture and collapse of the right main landing gear.Sep 2, 1999 · N6915Z · Substantial damageNTSB FTW99LA251Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Big Spring, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.Sep 2, 1999 · N4660M · Substantial damageNTSB DCA99WA077Incident · No injuriesForeign investigationBoeing 747SP · Taipei, TaiwanSep 2, 1999 · UNK · Substantial damageNTSB CHI99LA354Accident · No injuriesLimited investigationFinal reportCessna 150L · Midland, MIthe student pilot's failure to maintain control of the airplane during an attempted go-around.Sep 2, 1999 · N1316Q · Substantial damageNTSB CHI99FA332Accident · 1 fatalField investigationFinal reportPiper PA-12 · Neguanee, MIthe pilot failed to maintain clearance from the tower.Sep 2, 1999 · N91901 · DestroyedNTSB ANC99LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's failure to avoid obstructions during takeoff. A factor associated with this accident was the high brush along the river bank.Sep 2, 1999 · N9130D · Substantial damageNTSB SEA99LA169Accident · No injuriesLimited investigationFinal reportBeech J-35 · Union, ORDirectional control not maintained. A rough/uneven landing area was a factor.Sep 1, 1999 · N7299B · Substantial damageNTSB NYC99LA217Accident · No injuriesLimited investigationFinal reportHughes 269C · Utica, NYThe pilot's failure to maintain control of the helicopter while maneuvering, which resulted in a hard landing. A factor in this accident was the pilot's lack of total experience in helicopters.Sep 1, 1999 · N58397 · Substantial damageNTSB MIA99LA242Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-29 · Fort Lauderdale, FLan in-flight failure of the right aileron due to fatigue cracking in the attachment structure of the right inboard aerodynamic compensator, which resulted in a loss of control, a forced landing, and subsequent impact with the ground.Sep 1, 1999 · N52PB · DestroyedNTSB LAX99LA293Accident · No injuriesLimited investigationFinal reportBell 206B · Delhi, CAThe loss of engine power due to the pilot's inadequate preflight, which failed to detect water contamination of the fuel system. The operator's inadequate maintenance of the loose fitting fuel cap and the deformed filler opening, which allowed water to leak…Sep 1, 1999 · N59551 · Substantial damageNTSB LAX99LA292Accident · 2 fatalLimited investigationFinal reportHughes 369HS · Pohnpei (Pacific Ocean)An in-flight collision with the water for undetermined reasons.Sep 1, 1999 · N42054 · DestroyedNTSB LAX99LA290Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Boulder City, NVthe student pilot's failure to maintain directional control of the airplane during the takeoff roll.Sep 1, 1999 · N8675W · Substantial damageNTSB IAD99RA063Accident · 12 fatalForeign investigationCessna 404 · Arusha, TanzaniaSep 1, 1999 · 5HNATNTSB DEN99LA161Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Heber City, UTThe pilot's failure to maintain aircraft control during takeoff roll. Factors were the gusting crosswind conditions, and the airport sign.Sep 1, 1999 · N86096 · Substantial damageNTSB DEN99FA158Accident · 2 fatalField investigationFinal reportWroblewski RV-4 · Bayfield, COThe pilot's failure to maintain control of the aircraft for undetermined reasons.Sep 1, 1999 · N95PW · DestroyedNTSB DEN99FA157Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Villa Grove, COThe flight instructor's improper inflight decision to enter a narrow blind/box canyon, and his misjudgment of the vertical and lateral clearances. A factor was the downdrafts.Sep 1, 1999 · N4366D · DestroyedNTSB ATL99LA121Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cairo, GAThe loss of engine power for undetermined reasons. Factors were weather conditions favorable for the formation of carburetor ice.Sep 1, 1999 · N8965Q · Substantial damageNTSB ATL99LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Baker, FLThe flight instructor misjudged his altitude and airspeed. A factor was trees.Sep 1, 1999 · N5377L · Substantial damageNTSB SEA99LA151Accident · 1 fatalLimited investigationFinal reportRotordyne 200 · Kent, WAThe owner/builder's failure to properly torque the rotor blade retaining bolts.Aug 31, 1999 · N85Z · DestroyedNTSB NYC99FA216Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Plymouth, MAThe flight instructor's inadequate remedial action, and the pilot-under-instruction's panic and subsequent interference with the flight controls.Aug 31, 1999 · N98FM · DestroyedNTSB DEN99LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Peyton, COThe pilot's loss of control resulting in inadvertent stall/mush during initial climb following takeoff. Factors were the unfavorable, sudden windshift conditions, the high density altitude, and the manufacturer's failure to provide adequate density altitude…Aug 31, 1999 · N5172L · DestroyedNTSB DCA99RA076Accident · 80 fatalForeign investigationBoeing 737-200 · Ba, ArgentinaAug 31, 1999 · LVWRZNTSB ANC99LA131Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were a crosswind, and wind gusts.Aug 31, 1999 · N3824M · Substantial damageNTSB SEA99WA172Accident · Serious injuriesForeign investigationDouglas DC-3 · Santa Rosa, PhilippinesAug 30, 1999 · RPC47 · Substantial damageNTSB FTW99LA244Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Seminole, TXThe pilot seat disengaging from the seat track resulting from inadequate AD compliance during the last annual inspection. A factor was the soft terrain.Aug 30, 1999 · N731JY · Substantial damageNTSB FTW99LA243Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Jonesboro, ARThe pilot's misjudgment of distance/altitude during the final approach to landing, resulting in an undershoot, and collision with a power line pole.Aug 30, 1999 · N3255Y · Substantial damageNTSB CHI99LA315Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Eden Prairie, MNthe failure of the pilot to follow the landing checklist and his failure to extend the landing gear.Aug 30, 1999 · N6606P · Substantial damageNTSB ANC99LA126Accident · No injuriesLimited investigationFinal reportCessna A185E · Anchorage, AKThe total loss of engine power for an undetermined reason.Aug 30, 1999 · N124LR · Substantial damageNTSB SEA99FA152Accident · 3 fatalField investigationFinal reportCessna T210M · Marcola, ORThe pilot's failure to maintain clearance from the terrain while descending in an area of deteriorating weather. Factors include mountainous terrain, clouds, low ceilings, the pilot's inadequate preflight weather analysis, and his improper decision to attempt…Aug 29, 1999 · N747CC · DestroyedNTSB NYC99FA213Accident · 3 fatalField investigationFinal reportCessna 172N · Sussex, NJThe pilot's improper decision to takeoff with a tailwind. Factor's in this accident were the tailwind condition and pressure to depart caused by other airplanes performing successful downwind departures.Aug 29, 1999 · N737CJ · Substantial damageNTSB MIA99LA241Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Winter Haven, FLthe pilot-in command/flight instructor allowed the student pilot to get the nose of the airplane too low in the water causing a loss of directional control and a subsequent impact of the right wing in the water.Aug 29, 1999 · N8002H · Substantial damageNTSB LAX99LA289Accident · Minor injuriesLimited investigationFinal reportCessna P210N · North Las Vegas, NVThe pilot's improper procedure in that he failed to follow the flight manual, resulting in a loss of engine power and subsequent collision with the ground.Aug 29, 1999 · N40RP · Substantial damageNTSB LAX99LA288Accident · Minor injuriesLimited investigationFinal reportWirth Avid Flyer · Schellville, CAThe pilot's encounter with wind shear and a downdraft which precipitated his loss of airplane control.Aug 29, 1999 · N625F · DestroyedNTSB IAD99WA062Accident · 2 fatalForeign investigationLearjet 35A · Adwa, EthiopiaAug 29, 1999 · N350JF · DestroyedNTSB IAD99LA061Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Bedminster, NJthe pilot's medical incapacitation after suffering a massive stroke.Aug 29, 1999 · N19DQ · DestroyedNTSB CHI99LA335Accident · No injuriesLimited investigationFinal reportBenson Sorrell SNS-7 · Mt. Vernon, ILthe pilot's inadequate compensation for the wind condition which resulted in an inadvertent ground loop. A factor associated with the accident was the gusty crosswind.Aug 29, 1999 · N60SV · Substantial damageNTSB ANC99FA128Accident · 2 fatalField investigationFinal reportCessna 170B · Cooper Landing, AKThe pilot's inadvertent stall.Aug 29, 1999 · N3402D · DestroyedNTSB SEA99FA150Accident · 4 fatalField investigationFinal reportCessna 182E · Ryegate, MTThe pilot's continued VFR flight into IMC conditions and his failure to maintain clearance from mountainous terrain. Factors include low ceilings and inadequate in-flight planning.Aug 28, 1999 · N2886Y · DestroyedNTSB NYC99LA215Accident · No injuriesLimited investigationFinal reportLet L-33-SOLO · Wellington, OHThe pilot's failure to attain the proper touchdown point. A factor related to the accident was a downdraft.Aug 28, 1999 · N286BA · Substantial damageNTSB MIA99WA244Accident · 4 fatalForeign investigationCessna 206 · La Ceiba, HondurasAug 28, 1999 · HRAJM · DestroyedNTSB MIA99LA243Accident · No injuriesLimited investigationFinal reportPowers Rotorway Exec 162 · Lutz, FLa loss of power due to undetermined reasons, resulting in a forced landing and subsequent impact with the ground. A factor in this accident was the pilot was not qualified or certified in helicopters.Aug 28, 1999 · N314SP · Substantial damageNTSB LAX99LA287Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Emigrant Gap, CAThe fatigue failure and separation of the number three cylinder due to the cylinder overhaul facility's improper inspection and quality control processes.Aug 28, 1999 · N4201S · Substantial damageNTSB FTW99LA241Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Alpine, TXThe pilot's improper use of the emergency fuel boost pump, which resulted in excessive fuel flow to the engine and subsequent total loss of left engine power. Factor's were the high density altitude, the pilot exceeding the airplane's weight and balance, the…Aug 28, 1999 · N67JM · Destroyed