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 FTW93LA193Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Holly Grove, ARTotal loss of power due to fuel exhaustion due to the pilot not refueling. A factor was the lack of suitable terrain for the forced landing.Jun 19, 1993 · N4804Q · Substantial damageNTSB CHI93LA216Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Malden, MOA broken mixture control cable resulting in fuel starvation.Jun 19, 1993 · N9941U · Substantial damageNTSB ANC93LA100Accident · No injuriesLimited investigationFinal reportCessna 180 · Merrill Pass, AKThe pilot-in-command's inadequate fuel calculations.Jun 19, 1993 · N7627A · Substantial damageNTSB ANC93LA098Accident · No injuriesLimited investigationFinal reportCessna 207 · Grayling, AKThe partial failure of the airplane's braking system.Jun 19, 1993 · N9869M · Substantial damageNTSB SEA93LA134Accident · Minor injuriesLimited investigationFinal reportRomig FR-1 · Independence, ORFuel starvation and the pilot-in-command's not maintaining directional control. Factors contributing to the accident were the pilot-in-command's not selecting the fuel boost pump and high vegetation.Jun 18, 1993 · N876FR · Substantial damageNTSB NYC93LA119Accident · No injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Columbus, OHThe pilot's selection of unsuitable terrain for landing. A factor related to the accident was the interruption of the glider pilot's planned approach by a powered airplane.Jun 18, 1993 · N101AZ · Substantial damageNTSB NYC93LA117Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Holbrook, NYThe engine failure as the result of a fractured crankshaft due to metal fatigue.Jun 18, 1993 · N735CA · DestroyedNTSB NYC93FA118Accident · 3 fatalField investigationFinal reportCessna P210 · Marthas Vineyrd, MAThe pilot's failure to maintain control of the airplane.Jun 18, 1993 · N73CE · DestroyedNTSB CHI93LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Galesburg, ILThe departing pilot's (N251NW) inadequate visual lookout while operating in VFR conditions at an uncontrolled airport. Factors related to the accident were: the departing pilot's diverted attention, and the arriving pilot's (N2632U) inadequate visual lookout.Jun 18, 1993 · N2632U · 2 aircraft · Substantial damageNTSB CHI93LA213Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Birch Tree, MOThe pilot's failure to maintain aircraft control.Jun 18, 1993 · N8476G · Substantial damageNTSB ATL93IA113Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Savannah, GALeakage of the number 7 fuel nozzle, which resulted in an in flight engine fire.Jun 18, 1993 · N467AA · Minor damageNTSB ANC93T#A02Accident · No injuriesClass 3Final reportDe Havilland DHC-2 · Tenakee Springs, AKJun 18, 1993 · N450DB · Substantial damageNTSB ANC93LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Katmai, AKThe unsuitable terrain selected by the pilot-in-command. Factor was soft terrain condition.Jun 18, 1993 · N7300G · Substantial damageNTSB ANC93LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Juneau, AKThe pilot continuing VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the mountainous terrain, the cloudy weather conditions in the pass, the pilot becoming disoriented, his lack of familiarity with the…Jun 18, 1993 · N30505 · Substantial damageNTSB ANC93LA095Accident · No injuriesLimited investigationFinal reportBell B-3 · Annette Bay, AKThe failure of the tail rotor drive shaft coupling and the inadequate inspection of the tail rotor drive system by company maintenance personnel after the first tail rotor strike.Jun 18, 1993 · N21424 · Substantial damageNTSB ANC93LA094Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Dry Creek, AKThe loss of engine power for undetermined reasons.Jun 18, 1993 · N318C · Substantial damageNTSB SEA93LA132Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Augusta, MTThe pilot's failure to maintain airspeed and terrain clearance while maneuvering on an aerial application flight. A factor relating to the accident was the pilot's diverted attention.Jun 17, 1993 · N9952J · Substantial damageNTSB NYC93LA121Accident · No injuriesLimited investigationFinal reportCessna 182Q · Randolph Center, VTThe pilot selected unsuitable terrain which resulted in collapse of the landing gear and the airplane nosing over. A contributing factor was a soft/wet runway.Jun 17, 1993 · N5091N · Substantial damageNTSB NYC93LA116Accident · No injuriesLimited investigationFinal reportGritter Quest AIR 20 · Baltimore, MDThe failure of the left main gear tire which resulted in a loss of directional control and collision with a taxiway sign.Jun 17, 1993 · N116CP · Substantial damageNTSB NYC93FA115Accident · 1 fatalField investigationFinal reportEnstrom F28C · Gordon, KYThe pilot's failure to see and avoid the wire.Jun 17, 1993 · N200NH · DestroyedNTSB LAX93LA258Accident · No injuriesLimited investigationFinal reportBell 206B3 · Stoneyford, CAthe pilot's inadequate compensation for the existing wind conditions during a hover operation. A factor in the accident was the high density altitude and the gusting, variable wind conditions.Jun 17, 1993 · N38EA · Substantial damageNTSB FTW93TA#06Accident · No injuriesFinal reportCessna CE-550 · Comayagua, HondurasJun 17, 1993 · N2734K · Substantial damageNTSB FTW93LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Navasota, TXPartial power loss due to left magneto fluctuating due to loose coil. A factor was the lack of suitable terrain for the forced landingJun 16, 1993 · N11069 · Substantial damageNTSB ATL93LA112Accident · Serious injuriesLimited investigationFinal reportCessna 172 · St. Elmo, ALThe pilot's failure to maintain adequate clearance from the trees located near the departure end of the runway. Factors were the pilot's failure to use the entire runway for the takeoff, and the trees located near the departure end of the runway.Jun 16, 1993 · N8322B · Substantial damageNTSB ANC93LA091Accident · No injuriesLimited investigationFinal reportAeronca AR11 · Anchorage, AKFailure of the student pilot to maintain directional control, which resulted in a ground swerve, and inadequate supervision by the flight instructor. A factor related to the accident was: the soft/wet (muddy) terrain at the edge of the runway.Jun 16, 1993 · N4000E · Substantial damageNTSB NYC93LA114Accident · No injuriesLimited investigationFinal reportPitts S-2B · East Palestine, OHThe pilot's failure to maintain control of the aircraft. The pilot's improper compensation for the wind condition is a contributing factor.Jun 15, 1993 · N54DR · Substantial damageNTSB MIA93LA143Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Orlando, FLUnsuitable terrain encountered during the autorotative forced landing. Contributing to the accident was total loss of engine power due to seizure of the compressor impeller following failure of the no.2 bearing for undetermined reasons.Jun 15, 1993 · N500RT · Substantial damageNTSB FTW93LA190Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Wynne, ARThe engine power loss for undetermined reasons and the lack of suitable terrain for a forced landing.Jun 15, 1993 · N4955X · Substantial damageNTSB CHI93LA210Accident · No injuriesLimited investigationFinal reportBeech B19 · Janesville, WIThe pilot's improper landing flare.Jun 15, 1993 · N24674 · Substantial damageNTSB CHI93LA209Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newark, ILThe pilot's premature liftoff.Jun 15, 1993 · N381CF · Substantial damageNTSB CHI93LA208Accident · No injuriesLimited investigationFinal reportHughes 269 · Valley City, NDthe pilot-in-command's failure to maintain clearance from a tree during an aerial application manuever.Jun 15, 1993 · N213MS · Substantial damageNTSB ATL93IA111Incident · No injuriesIncident investigationFinal reportSikorsky S-76A · Cullman, ALThe failure of company maintenance personnel to properly inspect the tail rotor control cable at the last 750 hour inspection, and the subsequent total failure of the cable due to wear.Jun 15, 1993 · N110AL · No damageNTSB ANC93LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe pilot in command selected unsuitable terrain on which to land on. A factor in the accident was the rough/uneven, soft terrain.Jun 15, 1993 · N2571H · Substantial damageNTSB SEA93LA131Accident · No injuriesLimited investigationFinal reportChampion 7GC · Gillette, WYThe pilot in command's not maintaining directional control and the overload of the left main landing gear. A factor contributing to the accident was the pilot's lack of experience in conventionally geared aircraft.Jun 14, 1993 · N8947R · Substantial damageNTSB SEA93LA130Accident · No injuriesLimited investigationFinal reportBeech H35 · Douglas, WYThe improper maintenance/replacement of a fuel hose and the blocked fuel vapor return system. A factor relating to the accident was the cattle guard fence posts beside the road.Jun 14, 1993 · N368B · Substantial damageNTSB NYC93IA113Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60-200 · Atlantic City, NJA malfunction of the cargo fire warning system which resulted in a false alarm.Jun 14, 1993 · N711HJ · No damageNTSB LAX93LA257Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Oakdale, CAthe failure of the flying pilot to maintain directional control of the aircraft during the takeoff ground roll. A factor in the accident was the flying pilot's lack of recent total flight time and recent experience in conventional landing gear equipped…Jun 14, 1993 · N9618D · Substantial damageNTSB FTW93LA189Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Weiner, ARProper rotation speed not attained by the pilotJun 14, 1993 · N3098W · Substantial damageNTSB CHI93LA212Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Buckner, MOThe nut backing off the connecting rod bolt resulting in rod failure. A factor involved in this accident was the lack of suitable terrain for the pilot in command to make a run on landing.Jun 14, 1993 · N51717 · Substantial damageNTSB CHI93LA205Accident · No injuriesLimited investigationFinal reportCessna 172P · Hartford, WIThe failure of the number four cylinder and unsuitable terrain.Jun 14, 1993 · N55404 · Substantial damageNTSB SEA93LA129Accident · Minor injuriesLimited investigationFinal reportCessna T210K · Forest Grove, ORLoss of engine power due to fuel exhaustion, resulting from inadequate preflight planning/preparation by the PIC.Jun 13, 1993 · N8120G · Substantial damageNTSB NYC93LA112Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Kutztown, PAThe pilot's failure to maintain the proper glidepath and execute a proper flare. Lack of familiarity is a contributing factor.Jun 13, 1993 · N6795Z · Substantial damageNTSB NYC93LA111Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Woodstock, CTA complete loss of engine power for undetermined reasons.Jun 13, 1993 · N6158B · Substantial damageNTSB NYC93FA110Accident · 1 fatalField investigationFinal reportSkillman Thorp T-18 · Chatham, MAthe pilot's performance of an aerobatic maneuver, with insufficient altitude for recovery, resulting in a collision with the waterJun 13, 1993 · N221DP · DestroyedNTSB LAX93LA253Accident · No injuriesLimited investigationFinal reportCessna 152 · Tracy, CAThe failure of dual student to maintain an adequate airspeed during the go around initiation, and, the inadequate supervision of the flight by the instructor.Jun 13, 1993 · N6457L · Substantial damageNTSB LAX93LA252Accident · No injuriesLimited investigationFinal reportCessna 210L · Douglas, AZThe pilot's premature retraction of the landing gear and flaps at a critical time in the takeoff initial climb and his failure to attain an adequate climb airspeed which resulted in an inadvertent stall/mush condition. A factor in the accident was the high…Jun 13, 1993 · N29133 · Substantial damageNTSB LAX93LA248Accident · 1 fatalLimited investigationFinal reportHenderson Rutan Long EZ · San Pedro Bay, CAthe pilots failure to maintain an adequate terrain clearance altitude while maneuvering over the water at low altitude.Jun 13, 1993 · N874PM · DestroyedNTSB LAX93LA247Accident · 2 fatalLimited investigationFinal reportTucker Thorp T18C · So. Lake Tahoe, CAA total loss of engine power for undetermined reasons, and the failure of the pilot to maintain control of the aircraft while maneuvering at a low altitude.Jun 13, 1993 · N794PT · DestroyedNTSB FTW93LA188Accident · No injuriesLimited investigationFinal reportReims Cessna FA 150K · Willis, TXLoss of partial engine power due to stuck exhaust valve and exhaust and intake valve binding with carbon buildup. A factor was the lack of suitable terrainJun 13, 1993 · N922SZ · Substantial damageNTSB CHI93LA207Accident · No injuriesLimited investigationFinal reportRobert L. Kennedy Avid Flyer · White Pigeon, MIThe pilot in command's inability to attain proper touch down point. The improperly adjusted idle setting which resulted in the loss of engine power was also a cause.Jun 13, 1993 · N138RK · Substantial damage