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 FTW93FA165Accident · 4 fatalField investigationFinal reportFairchild SA-226T · Santa Fe, NMThe pilot's poorly planned circling approach, and his failure to maintain an adequate altitude. Factors which contributed to the accident were: the dark night and a lack of visual reference.May 26, 1993 · N241DT · DestroyedNTSB DEN93FA063Accident · 2 fatalField investigationFinal reportMooney M20E · Westcliffe, COThe pilot's loss of aircraft control as he attempted to turn away from a line of thunderstorms. Factors were thunderstorms and associated turbulence.May 26, 1993 · N5741Q · DestroyedNTSB BFO93LA097Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Reedsville, PATailwheel landing gear system components failing due to their worn condition resulting in the loss of ground steering capability. A factor in this accident was a gusting crosswind encountered during landing roll.May 26, 1993 · N2510Z · Substantial damageNTSB ANC93IA085Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · King Salmon, AKThe failure of the main gear upper strut assembly due to stress corrosion.May 26, 1993 · N3588Z · Minor damageNTSB SEA93LA122Accident · No injuriesLimited investigationFinal reportCessna TU206G · Mountain Home, IDCompensation for wind conditions was inadequate. The wind gusts were a factor.May 25, 1993 · N5203X · Substantial damageNTSB SEA93LA121Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Afton, WYA loss of engine power for an undetermined reason(s).May 25, 1993 · N7569Y · DestroyedNTSB LAX93IA235Incident · No injuriesIncident investigationFinal reportUS/Lta 138-S · Santa Maria, CAInadequate specifications in the design and manufacture of a rudder control tube rod end bearing by the airship manufacturer.May 25, 1993 · N832US · Minor damageNTSB LAX93FA223Accident · 2 fatalField investigationFinal reportCessna 172N · Lompoc, CAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude (or clearance) from mountainous terrain. Factors relating to the accident were: the low ceiling, fog, drizzle, obscuration, and mountainous…May 25, 1993 · N4783J · DestroyedNTSB FTW93LA166Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Mount Vernon, TXThe pilot's inadequate compensation for the crosswind.May 25, 1993 · N7554F · Substantial damageNTSB FTW93FA163Accident · No injuriesField investigationFinal reportMBB BK 117 A-4 · Lafayette, LACyclic control rod movement was restricted due to improper installation of the lateral cyclic control rod by company maintenance personnel.May 25, 1993 · N401PH · Substantial damageNTSB ANC93LA068Accident · No injuriesLimited investigationFinal reportCessna 402B · Kivalina, AKThe pilot's failure to check the condition of the runway before takeoff. The soft runway condition was a factor in the accident.May 25, 1993 · N401NA · Substantial damageNTSB LAX93LA225Accident · 1 fatalLimited investigationFinal reportCessna 172N · Page, AZthe pilot's selection of an inadequate cruise altitude. A factor in the accident was the high winds and turbulence in the vicinity of the cliffs.May 24, 1993 · N734DB · DestroyedNTSB LAX93LA222Accident · No injuriesLimited investigationFinal reportCessna 182P · Reno, NVIncorrect installation of a bearing in the airplane's alternator during overhaul by maintenance personnel. A factor in the accident was the rough, uneven terrain.May 24, 1993 · N642WR · Substantial damageNTSB FTW93LA164Accident · No injuriesLimited investigationFinal reportPiper PA-25-151 · Calera, OKAircraft performance exceeded and takeoff not aborted. Factors were the soft wet turf runwayMay 24, 1993 · N6129Z · Substantial damageNTSB SEA93LA120Accident · No injuriesLimited investigationFinal reportCessna 185A · Lowell, IDFatigue of the rocker arm and unsuitable terrain which was encountered during the precautionary landing.May 23, 1993 · N4080Y · Substantial damageNTSB SEA93LA119Accident · No injuriesLimited investigationFinal reportApplebay Zuni · Deer Park, WAImproperly planned approach by the PIC.May 23, 1993 · N4321D · Substantial damageNTSB SEA93LA118Accident · No injuriesLimited investigationFinal reportCessna 150M · Bellingham, WAThe inadequate compensation for wind conditions by the student pilot. Factors relating to the accident were the gusty wind conditions and the student's lack of total experience.May 23, 1993 · N63531 · Substantial damageNTSB MIA93FA129Accident · Serious injuriesField investigationFinal reportBeech F33A · Oxford, MSLoss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.May 23, 1993 · N3144H · Substantial damageNTSB LAX93LA221Accident · No injuriesLimited investigationFinal reportCessna 150E · Hollister, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft prior to departure.May 23, 1993 · N3051J · Substantial damageNTSB DEN93LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Buena Vista, COA downdraft and the pilot's failure to maintain directional control of the airplane. Factors were: a crosswind and the inadvertent selection of additional flaps.May 23, 1993 · N4881G · DestroyedNTSB ATL93LA096Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hartselle, ALThe pilot's misjudgement of distance and speed during the approach and landing.May 23, 1993 · N47GE · Substantial damageNTSB ANC93LA086Accident · No injuriesLimited investigationFinal reportCessna 185 · Barrow, AKThe fatigue fracture of the main landing gear spring.May 23, 1993 · N75LE · Substantial damageNTSB SEA93LA138Accident · No injuriesLimited investigationFinal reportBeech 60 · Bullfrog, UTInadvertent landing gear retraction.May 22, 1993 · N620E · Substantial damageNTSB MIA93LA128Accident · No injuriesLimited investigationFinal reportJohn Shufflebarger Zenair Zodiak · Lakeland, FLThe failure of the pilot-in-command to maintain airspeed after separation of the canopy, resulting in the aircraft entering a stall/mush condition and descending uncontrolled to the ground. Contributing to the accident was the failure of the pilot-in-command…May 22, 1993 · N693JS · Substantial damageNTSB FTW93LA162Accident · No injuriesLimited investigationFinal reportCessna A185F · Timbalier Isle, LAPilot's inadequate preflight planning and preparation in the selection of his takeoff route. A factor was the sand barMay 22, 1993 · N3588 · Substantial damageNTSB CHI93FA180Accident · 1 fatalField investigationFinal reportBeech C-18S · North Branch, MNexcessive use of brakes by the pilot-in-command.May 22, 1993 · N67E · DestroyedNTSB ATL93LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Athens, TNFailure of the aircraft engine to produce power for unknown reasons.May 22, 1993 · N1497V · Substantial damageNTSB SEA93LA117Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Brigham City, UTThe premature liftoff by the PIC and his failure to attain proper rate of climb. Factors relating to the accident were the gusty crosswind weather conditions, the failure of the PIC to use all available runway, and transmission wires.May 21, 1993 · N8589K · DestroyedNTSB SEA93LA116Accident · Serious injuriesLimited investigationFinal reportRambow Monnett Moni · Ritzville, WAThe improper landing flare.May 21, 1993 · N106NR · Substantial damageNTSB MIA93LA126Accident · No injuriesLimited investigationFinal reportCessna 170B · Titusville, FLThe pilot-in-command's failure to compensate for wind conditions, resulting in loss of directional control during landing roll.May 21, 1993 · N48021 · Substantial damageNTSB MIA93FA127Accident · 4 fatalField investigationFinal reportCessna 172N · Deerfield Beach, FLFailure of the pilot-in-command to maintain airspeed (vso). The low altitude at the time of the aerodynamic stall was a factor.May 21, 1993 · N4931D · DestroyedNTSB LAX93LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Vacaville, CAthe pilot's failure to maintain directional control after encountering strong and gusty cross winds during the landing flare.May 21, 1993 · N9461P · Substantial damageNTSB FTW93LA161Accident · No injuriesLimited investigationFinal reportLewis RV4 · Tyler, TXPilot's loss of directional control.May 21, 1993 · N61DL · Substantial damageNTSB CHI93LA179Accident · Minor injuriesLimited investigationFinal reportBell 47 · Berlin, WIThe pilot-in-command's failure to see the obstruction.May 21, 1993 · N8458E · DestroyedNTSB CHI93LA178Accident · No injuriesLimited investigationFinal reportCessna 188A · Harrisonville, MOPilot in command's failure to attain a proper climb.May 21, 1993 · N4426Q · Substantial damageNTSB CHI93LA177Accident · 1 fatalLimited investigationFinal reportCessna 120 · Crawford, NEThe pilot's failure to maintain adequate airspeed.May 21, 1993 · N2976N · DestroyedNTSB CHI93DCD02Accident · 1 fatalFinal reportPiper PA-25 · Essex, IAFatigue failure of the forward spar fuselage attachment assembly for the right wing. A factor related to the accident was: the lack of a directed inspection procedure that could have been provided with the issuance of an airworthiness directive.May 21, 1993 · N6453Z · DestroyedNTSB BFO93LA096Accident · No injuriesLimited investigationFinal reportRyan Navion · Cumberland, RILoss of engine power due to undetermined reasons. A factor related to the accident was rough and uneven terrain.May 21, 1993 · N4467K · Substantial damageNTSB BFO93LA095Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-233A · Johnson City, NYImproper planning/decision by the flight crew. Factors related to the accident were: the downdraft on final approach, the terrain conditions (cliff & obstructions) near the approach end of the runway, and the lack of relative experience for each of the pilots.May 21, 1993 · N17870 · Substantial damageNTSB SEA93LA113Accident · Minor injuriesLimited investigationFinal reportMurphy Barracuda · Yoncalla, ORThe engine oil filter vibrating loose resulting in oil starvation, and the pilot in command's misjudgment of winds. A factor contributing to the accident was unfavorable winds.May 20, 1993 · N54265 · Substantial damageNTSB MIA93LA125Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Sarasota, FLThe pilot-in-command's improper application of the flight controls during an autorotative landing, resulting in an in-flight collision with wires and terrain. Contributing to the accident was the improper inspection of the engine fuel system (carburetor) by…May 20, 1993 · N46937 · Substantial damageNTSB MIA93LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot-in-command's failure to initiate a climb.May 20, 1993 · N93137 · Substantial damageNTSB MIA93LA123Accident · No injuriesLimited investigationFinal reportCessna 172RG · Fort Lauderdale, FLThe failure of the left main gear pivot assembly, resulting in the collapse of the left main landing gear during the landing rollout.May 20, 1993 · N5338V · Substantial damageNTSB FTW93LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Belmont, LAThe loss of engine power due to a sheared accessory drive pin. A factor was the unsuitable terrainMay 20, 1993 · N25051 · Substantial damageNTSB ATL93LA094Accident · No injuriesLimited investigationFinal reportBellanca GC-BC · Panama City, FLThe failure of the pilot to maintain control of the aircraft and his poor inflight decision to attempt a downwind landing at the 975 foot airfield. A factor was the tail wind condition which existed at the airfield at the timeMay 20, 1993 · N2590Z · Substantial damageNTSB SEA93LA115Accident · No injuriesLimited investigationFinal reportLarkin Pitts Special · Nampa, IDThe pilot failed to maintain directional control during landing ground roll.May 19, 1993 · N100Q · Substantial damageNTSB SEA93LA114Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Moscow, IDThe inadequate visual lookout by the pilot and his failure to maintain clearance from electrical transmission wires. Factors relating to the accident were the sunglare and the presence of the wires.May 19, 1993 · N51458 · Substantial damageNTSB SEA93LA112Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Hardin, MTThe pilot in command's failure to maintain directional control.May 19, 1993 · N9041R · Substantial damageNTSB CHI93LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Mexico, MOa loss of engine power for undetermined reasons. A factor in the accident was the soft field landing site.May 19, 1993 · N8787L · Substantial damageNTSB ANC93LA066Accident · No injuriesLimited investigationFinal reportCessna 180H · Ketchikan, AKThe pilot in commands improper compensation for the wind condition. A factor in the accident was the unfavorable wind.May 19, 1993 · N8237V · Destroyed