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 FTW95FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-502A · Coleman, TXthe pilot's continued flight into adverse weather resulting in spatial disorientation and loss of control. A factor was the pilot's improper weather evaluation and the weather.Sep 21, 1995 · N91969 · DestroyedNTSB CHI95FA328Accident · 1 fatalField investigationFinal reportCessna 421B · Coldwater, MIfailure of the pilot to maintain adequate airspeed, while maneuvering (turning) at low altitude, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the adverse weather conditions, and the lack of…Sep 21, 1995 · N14A · DestroyedNTSB ATL95LA171Accident · No injuriesLimited investigationFinal reportBell 47G · Union City, TNFailure of a #4 connecting rod bolt, which resulted in engine stoppage and a forced landing.Sep 21, 1995 · N616X · Substantial damageNTSB ANC95LA172Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Aniak, AKThe pilot's inadequate weather evaluation. Factors associated with the accident were: the box canyon, rising terrain, wind gusts, and downdrafts.Sep 21, 1995 · N56564 · Substantial damageNTSB SEA95LA227Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Yakima, WAFatigue failure of the bolt attaching the scissor arm assembly to the pitch control support assembly. The failure of the bolt led to a loss of collective pitch control and reduced rotor RPM.Sep 20, 1995 · N38115 · Substantial damageNTSB MIA95WA228Accident · No injuriesForeign investigationCessna A188B · Port Of Spain, Trinidad & TobagoSep 20, 1995 · N21740 · Substantial damageNTSB LAX95FA339Accident · 1 fatalField investigationFinal reportBell 206L-1 · Irvine, CAthe pilot's intentional VFR flight into IMC conditions and failure to maintain an adequate terrain clearance altitude, and the local controller's improper use of ATC procedure/technique. Factors in the accident were the helicopter's low fuel state and lack of…Sep 20, 1995 · N700TH · DestroyedNTSB CHI95LA327Accident · Minor injuriesLimited investigationFinal reportBell 206L · Ware, ILthe pilot's failure to maintain control of the helicopter. A factor in the accident was the pilot's inadvertent VFR flight into IMC conditions.Sep 20, 1995 · N2777W · Substantial damageNTSB BFO95LA096Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Medina, OHthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. High vegetation (tall corn) in the emergency landing area was a related factor.Sep 19, 1995 · N1424R · Substantial damageNTSB SEA95LA221Accident · Serious injuriesLimited investigationFinal reportBell UH-1L · Grace, IDthe fatigue failure of the centrifugal impeller and the lack of suitable terrain for a forced landing. Factors contributing to the accident were: the lack of required compliance with the FAA Airworthiness Directive by the operator, the insufficiently defined…Sep 18, 1995 · N70410 · DestroyedNTSB NYC95LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auburn, MAThe loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a related factor.Sep 18, 1995 · N4319T · Substantial damageNTSB LAX95FA338Accident · Minor injuriesField investigationFinal reportSwearingen SA-226T · Chino, CAThe pilot's improper IFR procedure by not initiating a missed approach at the outer marker, by attempting to intercept the glideslope from above after passing the outer marker, and by allowing the airplane to continue descending after reaching the decision…Sep 18, 1995 · N693PG · DestroyedNTSB FTW95IA397Incident · No injuriesIncident investigationFinal reportMBB BO-105C · Lafayette, LAa short in the 'jam proof system' solenoid valve which prevented activation of the backup hydraulic system and resulting in a cyclic hardover. Factors were the contaminated hydraulic fluid and the resulting jammed actuator (longitudinal control slider).Sep 18, 1995 · N91070 · No damageNTSB SEA95LA220Accident · No injuriesLimited investigationFinal reportHiller UH-12A · Bonners Ferry, IDThe flight instructor's misjudging his flare during a simulated autorotation.Sep 17, 1995 · N8180H · Substantial damageNTSB MIA95LA225Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU-2-22K · Picayune, MSThe pilot-in-command's disregard of a weather forecast and flight into known adverse weather condition (thunderstorm). The thunderstorm, and associated wind gusts, were factors.Sep 17, 1995 · N2717Z · DestroyedNTSB LAX95LA337Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Parker Dam, CAthe pilot's failure to maintain adequate airspeed during a go-around.Sep 17, 1995 · N41544 · Substantial damageNTSB CHI95LA341Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · South Bend, INthe Pilot-in-Command's inadequate supervision of the flight and failure to assure that proper airspeed, rate of climb, and clearance from trees were obtained/maintained.Sep 17, 1995 · N169GA · Substantial damageNTSB CHI95LA323Accident · 1 fatalLimited investigationFinal reportHaugen Kolb Firestar II · Souris, NDthe pilot's failure to maintain control of the ultralight vehicle.Sep 17, 1995 · N42996 · DestroyedNTSB CHI95LA322Accident · Minor injuriesLimited investigationFinal reportBenham F8L Falco · Augusta, KSa sudden shift in wind direction which resulted in diminished airspeed during takeoff.Sep 17, 1995 · N11HM · DestroyedNTSB ANC95LA171Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Aniak, AKThe pilot's selection of an unsuitable portion of the 6,000 foot long gravel runway for landing. A factor associated with the accident was: the soft gravel berm on the runway.Sep 17, 1995 · N3334M · Substantial damageNTSB FTW95LA400Accident · No injuriesLimited investigationFinal reportCessna 150K · Victoria, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.Sep 16, 1995 · N5DT · Substantial damageNTSB CHI95LA324Accident · No injuriesLimited investigationFinal reportCessna 177 · Camp Lake, WIthe pilot's inadequate compensation for wind conditions, and failure to maintain altitude/clearance from the power line, while on short final approach. The downdraft was a related factor.Sep 16, 1995 · N3497T · Substantial damageNTSB CHI95FA326Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Danville, INthe pilot-in-command's inadequate recovery while maneuvering.Sep 16, 1995 · N118AT · DestroyedNTSB ATL95LA169Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Plains, GAFailure of the number four cylinder rocker arm housing and pin, which resulted in a closed exhaust valve and loss of engine power.Sep 16, 1995 · N2362D · Substantial damageNTSB SEA95LA218Accident · No injuriesLimited investigationFinal reportCessna 180 · Pray, MTThe loss of directional control due to the loss of right tailwheel steering. Factors in the accident were: a left quartering crosswind and the sloped side of the road.Sep 15, 1995 · N11JW · Substantial damageNTSB NYC95LA222Accident · No injuriesLimited investigationFinal reportMooney M20J · Jonestown, PAthe pilot's failure to maintain adequate airspeed during a go-around.Sep 15, 1995 · N5688M · DestroyedNTSB MIA95WA232Accident · No injuriesForeign investigationAyres AY-65 · Bogota, ColombiaSep 15, 1995 · N3101D · Substantial damageNTSB MIA95FA224Accident · 3 fatalField investigationFinal reportAerospatiale TB-9 · New Smyrna Bch, FLthe failure of the pilots of both aircraft to see and avoid each other.Sep 15, 1995 · N117ER · 2 aircraft · DestroyedNTSB MIA95FA223Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Dalton, GAthe pilot's improper action by turning off the right engine fuel selector valve after the left engine had failed, and her failure to maintain control of the airplane after losing power in both engines. Factors relating to the accident were: a worn rocker arm…Sep 15, 1995 · N1543X · DestroyedNTSB LAX95LA335Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bakersfield, CAa loss of engine power for undetermined reasons.Sep 15, 1995 · N7498L · Substantial damageNTSB BFO95LA095Accident · No injuriesLimited investigationFinal reportSnow S2A · Pasadena, MDthe pilot's inability to maintain directional control due to the failure of the right brake during the landing roll.Sep 15, 1995 · N4977C · Substantial damageNTSB ANC95LA170Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKFailure of the main landing gear wheel that had been modified for a tundra tire.Sep 15, 1995 · N2940K · Substantial damageNTSB SEA95LA217Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Morgan, UTFailure of the pilot to maintain adequate airspeed, while maneuvering to land after a low altitude tow release, which resulted in a stall/spin and collision with terrain.Sep 14, 1995 · N2478W · DestroyedNTSB MIA95WA222Accident · 5 fatalForeign investigationCessna 402B · Marsh Harbour, BahamasSep 14, 1995 · N69303 · DestroyedNTSB LAX95LA336Accident · No injuriesLimited investigationFinal reportSjostrand Wheeler Express · Mariposa, CAthe pilot's premature rotation and liftoff, which resulted in an inadvertent stall and subsequent hard touchdown.Sep 14, 1995 · N360EZ · Substantial damageNTSB FTW95LA395Accident · Serious injuriesLimited investigationFinal reportSinclair 1100R · Guthrie, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall.Sep 14, 1995 · N9264C · DestroyedNTSB FTW95FA394Accident · No injuriesField investigationFinal reportMBB BO-105C · Houston, TXthe failure of the main transmission's #1 (left) input pinion assembly, due to the partially blocked oil passage which reduced oil flow, resulting in the disconnect of the drive shaft.Sep 14, 1995 · N650MS · DestroyedNTSB CHI95LA325Accident · No injuriesLimited investigationFinal reportBede BD12 · Chesterfield, MOThe airplane's inadequate handling characteristics which resulted in the inability to control pitch attitude during landing.Sep 14, 1995 · N112BD · Substantial damageNTSB ANC95FA167Accident · 2 fatalField investigationFinal reportCessna 185 · Petersburg, AKThe pilot's failure to maintain sufficient airspeed above the airplane's stall speed. The high terrain and low ceiling (clouds) were related factors.Sep 14, 1995 · N90033 · DestroyedNTSB MIA95LA221Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Hendersonville, NCThe failure of the pilot-in-command to perform preflight weight and balance calculations resulting in the airplane exceeding the maximum gross takeoff weight limitations.Sep 13, 1995 · N6721D · Substantial damageNTSB FTW95LA396Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Searcy, ARThe pilot's inadequate compensation for the winds. A factor was the crosswind.Sep 13, 1995 · N7729K · Substantial damageNTSB FTW95FA393Accident · 3 fatalField investigationFinal reportCessna 172M · Witter, ARfailure of the pilot to maintain sufficient altitude/clearance from high/wooded terrain. Factors relating to the accident were: darkness, high terrain, and foggy weather conditions. Also, the pilot's use of Methamphetamine (not approved by the FAA) was a…Sep 13, 1995 · N61899 · DestroyedNTSB CHI95LA321Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Boyne Falls, MIthe pilot's failure to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.Sep 13, 1995 · N76919 · Substantial damageNTSB ATL95LA168Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Minter City, MSInadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the excessive gross weight of the airplane and the high outside air temperature, which would have reduced the performance of the airplane.Sep 13, 1995 · N60237 · Substantial damageNTSB SEA95LA219Accident · No injuriesLimited investigationFinal reportPietenpol AIR-CAMPER · Redmond, ORa loss of engine power for undetermined reasons.Sep 12, 1995 · N18GH · Substantial damageNTSB LAX95GA334Accident · 2 fatalFinal reportCessna U206G · Dos Palos, CAthe pilot-in-command's failure to assure that adequate airspeed was maintained.Sep 12, 1995 · N6355U · DestroyedNTSB DCA95RA061Accident · 2 fatalForeign investigationBalloonbau Woerner · Bereza, BelarusSep 12, 1995 · CARIBNTSB ANC95LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Delta, AKThe pilot's selection of an unsuitable step taxi/takeoff area. The submerged object was a related factor.Sep 12, 1995 · N3991Z · Substantial damageNTSB ANC95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Kivalina, AKThe pilot's selection of unsuitable terrain for takeoff. A factor relating to the accident was: the rough/uneven terrain.Sep 12, 1995 · N7562K · Substantial damageNTSB SEA95LA216Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moab, UTThe pilot-in-command's landing long, precluding a go-around and not maintaining a proper descent rate. Factors were trees and the crosswind.Sep 11, 1995 · N9041E · Substantial damage