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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ATL93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Elizabethton, TNA loss of engine power on one engine for undetermined reasons.NTSB SEA93LA093Accident · No injuriesLimited investigationFinal reportCessna 172K · Pony, MTThe improper preflt planning by the PIC and his failure to attain takeoff airspeed during ground roll on a soft snow covered airstrip. A factor relating to the accident was the soft snow on the airstrip.NTSB SEA93FA094Accident · Serious injuriesField investigationFinal reportGrumman A6E · Steptoe, WAThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the crew of the A6E and the pilot of the agcat from recognizing a collision hazard and taking actions to avoid a midair…NTSB NYC93LA083Accident · No injuriesLimited investigationFinal reportRobinson R22B · Ronkonkoma, NYThe lack of adequate supervision and delayed remedial action by the flight instructor. A factor related to the accident was the delay in adding power by the student pilot which resulted in a low rotor RPM condition.NTSB NYC93GA082Accident · Minor injuriesFinal reportBell 206B · Lucasville, OHLoss of tail rotor effectiveness which resulted in the loss of aircraft control. A factor which contributed to the accident were unfavorable winds.NTSB MIA93LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe failure of the pilot-in-command to maintain directional control while landing with a crosswind.NTSB MIA93LA101Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Iuka, MSThe pilot's improper recovery from a bounced landing and the subsequent loss of control due to a stall/mush condition. Contributing to the accident was the pilot's lack of total experience.NTSB DCA93MA040Accident · Serious injuriesClass 1 · MajorFinal reportDouglas DC-10-30 · Dallas/Ft Worth, TXThe national transportation safety board determines that the probable cause of the accident was the failure of the captain to use proper directional control techniques to maintain the airplane on the runway.NTSB NYC93LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Farmingdale, NYThe pilot's inadequate compensation for wind conditions and failure to maintain control of the airplane. The crosswind was a related factor.NTSB FTW93LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Houston, TXFuel exhaustion induced power loss and the pilot's failure to refuel. A factor was the existing night conditionsNTSB FTW93FA128Accident · 2 fatalField investigationFinal reportCessna 172M · Hobart, OKInadvertent stall. Factors were the instructor pilot's spatial disorientation, his lack of total instrument time, the weather, and the dark night conditions.NTSB NYC93FA080Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Lapeer, NYThe pilot's improper inflight decision to continue flight into known icing conditions. Factors which contributed to the accident were: the pilot's failure to obtain updated weather information prior to departure, the icing conditions, and the degraded…NTSB MIA93LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Immokalee, FLThe decision of the pilot to buzz and his failure to maintain adequate visual lookout.NTSB MIA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Orlando, FLVisual lookout not maintained by the pilot-in-command while taxiing the airplane. Contributing to the accident was the failure of the driver of the vehicle to advise the ground controller that he had stopped the vehicle on the taxiway.NTSB LAX93LA170Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Torrance, CAFailure of the pilot to attain sufficient lift off airspeed. Factors in this accident were the pilot's overconfidence in his piloting skills, and the inadvertent stall of the airplane.NTSB FTW93IA125Incident · No injuriesIncident investigationFinal reportBoeing 747-269BC · Alexandria, LAThe inflight delamination of the wing panel skin. Factors were the water contamination of the honeycomb panel.NTSB FTW93FA126Accident · Serious injuriesField investigationFinal reportWard Pitts Special WSC-1 · Fort Worth, TXThe fire extinguisher in the cockpit came loose and jammed the right rudder pedal.NTSB CHI93FA135Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Kinsley, KSThe pilot initiated VFR flight into instrument meteorological conditions which resulted in a loss of aircraft control due to spatial disorientation. The adverse weather conditions were factors which contributed to the accident.NTSB ATL93LA071Accident · 1 fatalLimited investigationFinal reportKertesz Woody Pusher · Bradley, FLThe pilot's failure to maintain airspeed during maneuvering flight, which resulted in a stall/spin and collision with the terrain.NTSB ANC93LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Kasigluk, AKThe pilot's improper planning/decision and delay in aborting the takeoff. Factors related to the accident were: loose gravel on the surface of the runway and the snowbank (berm) on the overrun (stopway).NTSB MIA93WA098Accident · No injuriesForeign investigationPiper PA-32-260 · N. Eleuthera I., BahamasNTSB MIA93LA099Accident · 1 fatalLimited investigationFinal reportKojima, Jun Lewis Cavalier · Dekalb, MSFailure of the pilot-in-command to maintain adequate airspeed resulting in an inadvertent stall. Contributing to the accident was the lack of total experience by the pilot-in-command in the type operation.NTSB LAX93LA283Accident · No injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Phoenix, AZThe pilot's inadequate planned approach to the landing area.NTSB LAX93FA173Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Novato, CAA loss of control for an undetermined reason(s).NTSB FTW93LA124Accident · No injuriesLimited investigationFinal reportViolet Dragonfly · Carlsbad, NMThe improper installation of the control stick assembly and the subsequent separation of the flight control stick assembly from the mountNTSB FTW93LA123Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Forrest City, ARThe pilot's improper landing flare. Factors were the wind conditions and pilot's failure to maintain directional control.NTSB CHI93IA140Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-ATP · Oshkosh, WIan inoperative engine nacelle anti-ice system, and ice ingestion.NTSB SEA93LA095Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS4A · Wenatchee, WAMisjudged weather evaluation. Factors include high winds encountered on approach.NTSB SEA93LA092Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Spokane, WAFailure of the number 4 cylinder exhaust valve seat and the inadvertent stalling of the aircraft by the pilot in command. Factors contributing to the accident were buildings and power lines.NTSB NYC93LA078Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Durham, NHImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power. Factors related to the accident were flight into adverse weather conditions, failure to obtain inflight weather information, and pilot fatigue.NTSB NYC93FA079Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2B · North Benton, OHThe pilot's failure to maintain adequate aircraft control due to alcohol impairment.NTSB MIA93LA097Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Bartow, FLThe pilot's inadequate compensation for wind conditions. The downdraft was a factor.NTSB LAX93LA171Accident · Minor injuriesLimited investigationFinal reportMong SPORT-S · Fallbrook, CAFailure of the pilot to visually clear the runway before starting the takeoff ground run. Factors in the accident were inadequate airspeed at the time of liftoff which resulted in an aerodynamic stall.NTSB FTW93LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Danville, ARPilot's improper crosswind correction, his loss of directional control, and improper supervision by the instructor pilot. A factor was the crosswindNTSB FTW93LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXThe pilot's improper compensation for wind conditions. A factor was the gusty crosswind.NTSB CHI93LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Towanda, KSThe pilot failed to adequately compensate for a gusty crosswind condition.NTSB CHI93LA134Accident · 1 fatalLimited investigationFinal reportCessna T188C · Belview, MNThe pilot-in-command's not maintaining proper altitude.NTSB CHI93IA152Incident · No injuriesIncident investigationFinal reportBoeing 767-233 · Kansas City, MOA frozen aileron control bearing after it had become worn, corroded and exposed to water, and the manufacturer's inadequate maintenance/inspection requirment of the bearing(s).NTSB NYC93LA077Accident · No injuriesLimited investigationFinal reportFawcett Titan Tornado · East Moriches, NYThe loss of engine power for undetermined reasons.NTSB NYC93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Dowingtown, PAThe loss of engine power for undetermined reasons.NTSB NYC93FA076Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Oxford, MAThe pilot's selection of the wrong runway for takeoff which resulted in not being able to obtain adequate airspeed for climbout. A factor which contributed to the accident was the tailwind.NTSB LAX93LA174Accident · No injuriesLimited investigationFinal reportCessna T310R · Groveland, CAFailure of the pilot to follow the airplane's checklist which resulted in an inadvertent gear up landing.NTSB LAX93LA169Accident · Serious injuriesLimited investigationFinal reportAero Commander 112 · Camarillo, CAThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion. Factors related to the accident were: improper preflight planning/preparation, inadequate fuel supply, refueling stop not performed, and no suitable terrain found in the…NTSB FTW93LA121Accident · No injuriesLimited investigationFinal reportCessna 150J · Waterproof, LAThe pilot's misjudged landing point and the excessive airspeed. A factor was the wet grass stripNTSB DEN93LA040Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Englewood, COThe pilot's improper compensation for wind conditions and his failure to maintain directional control. Factors were: a crosswind and tailwind component.NTSB SEA93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Hamilton, MTThe pilot's improper use of carburetor heat. A factor which contributed to the accident was the carburetor icing conditions.NTSB NYC93LA073Accident · No injuriesLimited investigationFinal reportBeech B19 · Old Bridge, NJThe pilot's improper flare and improper recovery from a bounced landing, which resulted in overload failure of the nose gear.NTSB LAX93LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe cfi's inadequate supervision of the flight and delaying the remedial action. The dual student's improper use of the brakes is a factor in this accident.NTSB FTW93LA120Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Midlothian, TXFailure of the engine cowling latch resulting in deteriorating airplane performance and a forced landing.NTSB FTW93LA119Accident · No injuriesLimited investigationFinal reportVaughan Mustang II · Las Cruces, NMThe aircrafts takeoff performance exceeded and pilot's failure to maintain directional control. A factor was the wind