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 NYC01FA062Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-51 · Jamaica, NYThe low cycle fatigue fracturing of the approach lighting cover securing bolts.NTSB MIA01WA053Accident · 2 fatalForeign investigationCessna 206 · Rio Sidra, PanamaNTSB LAX01LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Ramona, CAThe pilot's inadvertent encounter with a pothole during taxi, after landing.NTSB CHI01IA055Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135LR · Chicago, ILThe jammed horizontal stabilizer trim that occurred during the airplane's initial climb after takeoff. Factors relating to the incident were the inadequate capability of the horizontal stabilizer trim actuator to move the stabilizer during all flight phases,…NTSB NYC01LA076Accident · Serious injuriesLimited investigationFinal reportBoeing 767-300ER · Boston, MAThe vehicle driver's improper decision to pass behind an aircraft with operating engines, which resulted in an encounter with jet blast.NTSB MIA01LA052Accident · No injuriesLimited investigationFinal reportCessna 305A · Morganton, NCThe failure of the pilot to maintain aircraft control about the aircraft's lateral axis during landing rollout, and the resultant nose over.NTSB FTW01FAMS1Accident · 1 fatalMissing aircraftFinal reportBell 206B · High Island 116undetermined, missing aircraft.NTSB DEN01LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Longmont, COthe pilot's failure to mantain directional control during landing roll.NTSB CHI01LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Sturtevant, WIThe unsuitable terrain for landing selected by the student pilot, the inadequate initial training by the flight instructor, and the flight instructor's decision to send the student pilot on a solo flight in known adverse weather conditions. Factors to the…NTSB ANC01FAMS1Accident · 2 fatalMissing aircraftFinal reportChampion 8GCBC · Juneau, AKUndetermined. Missing airplane.NTSB MIA01LA049Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Ciales, PRthe flight crew's failure to follow procedures for a straight-in autorotation with power recovery that resulted in their improper use of collective resulting in a hard landing and substantial damage to the helicopter.NTSB MIA01IA051Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Hebron, KYThe inadequate design of the flight compartment windshield by the windshield manufacturer resulting in cracking of the center ply.NTSB LAX01LA065Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Colorado City, AZthe pilot's improper preflight and failure to refuel the airplane.NTSB CHI01LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · New Underwood, SDThe pilot's inadequate planning and preparation, which resulted in fuel exhaustion. A factor relating to this accident was the plowed field.NTSB FTW01LA041Accident · No injuriesLimited investigationFinal reportBeech BE-60 · Addison, TXThe pilot's misjudged flare of the airplane resulting from restricted forward visibility. Factors were the pilot's continued flight into known adverse weather conditions, the icing conditions, and the iced windshield.NTSB NYC01LA067Accident · No injuriesLimited investigationFinal reportRockwell 112A · Norwood, MAThe pilot's improper starting procedure, which resulted in an on-ground collision with a parked aircraft.NTSB NYC01LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mitchellville, MDA loss of engine power for undetermined reasons.NTSB DEN01LA034Accident · No injuriesLimited investigationFinal reportBarackman Vans RV-6 · Springfield, COTotal failure of the right hand flap control rod due to construction procedures/directives not being followed by the builder.NTSB DEN01FA033Accident · 2 fatalField investigationFinal reportBeech V35B · Albuquerque, NMthe pilot's failure to maintain aircraft control and the inadvertent stall. Factors contributing to the accident were the pilot's improper in-flight planning, his lack of recent flying experience, and the abrupt maneuver to correct to the proper runway.NTSB DCA01WA009Accident · No injuriesForeign investigationMcDonnell Douglas DC-10-10 · FAAA Tahiti, French PolynesiaNTSB LAX01LA064Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Bakersfield, CAThe pilot's inadequate in-flight planning, fuel management, and inadequate remedial actions, which resulted in a total loss of engine power due to fuel starvation. The pilot made an off-field landing and collided with a fence.NTSB SEA01LA031Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 Mk. I · Kirkland, WAA malfunction of the aircraft's fuel selector valve and subsequent fuel starvation. Factors included a short emergency landing area, a wet landing surface, and a fence.NTSB NYC01FA058Accident · 2 fatalField investigationFinal reportBeech B200 · Rangeley, METhe pilot-in-command's failure to maintain sufficient altitude while maneuvering to land, which resulted in a collision with terrain. Factors in the accident were the dark night, mountainous terrain, snow showers, clouds, and the pilot's decision to cancel…NTSB MIA01LA047Accident · No injuriesLimited investigationFinal reportLarry Groover Eagle · Auburndale, FLthe pilot's failure to maintain adequate clearance during takeoff, which resulted in an inflight collision with a fence and substantial damage to the aircraft.NTSB LAX01LA063Accident · Minor injuriesLimited investigationFinal reportBell 206-L3 · Wilcox, AZThe pilot's incapacitation that resulted from nausea during the final approach to landing. The pilot collapsed on the cyclic, which precipitated inadvertent contact between the main rotor blades and the ground. Factors were hilly terrain on a dark night,…NTSB FTW01LA044Accident · No injuriesLimited investigationFinal reportCessna TR182 · Little Rock, ARthe failure of the right main landing gear actuator.NTSB FTW01LA042Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B2 · Mesquite, TXThe student pilot's abrupt control input, which resulted in a tail rotor blade strike. Factors were the CFI's delay in taking remedial action and the student pilot's lack of total experience.NTSB ANC01LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Deadhorse, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were clouds, fog, dusk light conditions, and the pilot's self-induced pressure to complete the flight prior to nightfall.NTSB LAX01LA062Accident · No injuriesLimited investigationFinal reportCessna 177RG · San Carlos, CAA loss of engine power for undetermined reasons during an extended downwind leg in the landing pattern.NTSB DEN01LA032Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Aspen, COA hard landing which exceeded the design stress limits of the aircraft.NTSB MIA01WA046Accident · Serious injuriesForeign investigationCessna 402B · Nosara, Costa RicaNTSB MIA01LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Fort Pierce, FLThe pilot's improper approach for landing while making a landing following a reported momentary partial loss of engine power for undetermined reasons and his decision to make a go-around from the approach resulting in a landing in a field and collapse of the…NTSB DEN01FA030Accident · No injuriesField investigationFinal reportHawker Siddeley HS-125-700 · Jackson, WYThe pilot's failure to follow IFR approach procedures and perform a missed approach when the runway was not in sight below approach minimums. Contributing factors were the copilot's failure to follow current ILS approach procedures and use the correct…NTSB CHI01LA059Accident · No injuriesLimited investigationFinal reportBeech F33A · Winona, MNThe pilot not maintaining directional control during the landing roll. A factor was the snowbank.NTSB ANC01FA026Accident · 2 fatalField investigationFinal reportCurtis-Wright C46A · Kenai, AKThe flight crew's decision to continue VFR flight into instrument meteorological conditions. Factors associated with the accident are high winds, turbulence, and low ceilings.NTSB IAD01LA020Accident · No injuriesLimited investigationFinal reportCessna 172M · Medford, NJThe pilot's failure to attain the proper touchdown point. Factors included the loss of electrical power, the dark night, and the pilot's lack of night experience.NTSB CHI01LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Sturgis, SDThe pilot failed to maintain control of the airplane during takeoff and he discontinued an aborted takeoff once initiated. Factors associated with the accident were the inaccurate elevator trim indicator, the pilot's failure to verify the trim setting,…NTSB CHI01LA049Accident · No injuriesLimited investigationFinal reportCessna 210C · Indianapolis, INThe reason for the loss of engine power is undetermined. A factor was the rough terrain.NTSB NYC01LA059Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA365-N1 · West Mifflin, PAInsufficient lubrication within the tail rotor gearbox, which resulted in the seizure of the duplex ball bearing and a fixed pitch setting of the tail rotor. Also causal, was the pilot's loss of control, which was the result of a relative low speed/high power…NTSB FTW01LA038Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Hurst, TXthe flight instructor's failure to maintain directional control during the practice hydraulic off run-on landing. Contributing factors were the gusty wind conditions, and the non-breakaway runway edge light.NTSB CHI01LA050Accident · No injuriesLimited investigationFinal reportBeech 58 · Huntingburg, INThe proper touchdown point not obtained/maintained by the pilot. Factors were the snow covered runway, the ice contaminated windshield, and the airport snow removal performed by the driver of the vehicle.NTSB CHI01FA052Accident · 1 fatalField investigationFinal reportBeech BE-23 · Rolla, MOThe pilot's inadequate preflight during the pre-buy inspection, the pilot's incapacitation due to carbon monoxide, and the fractured muffler.NTSB LAX01LA060Accident · No injuriesLimited investigationFinal reportJohn D. Lueck Avid Amphibian · Las Vegas, NVThe failure of the landing gear axle for undetermined reasons.NTSB FTW01LA039Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sunnyvale, TXThe flight instructor's inadequate supervision of his student and his failure to maintain control of the helicopter. Factors were the student pilot allowing the airspeed and main rotor RPM to get too low during the simulated emergency.NTSB ANC01LA025Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe delayed remedial action by the pilot/instructor of another airplane during landing. Factors in the accident were the failure of the pilot of another airplane to maintain directional control, and the lack of available brakes to the pilot/instructor of…NTSB SEA01WA030Accident · 7 fatalForeign investigationAero Commander 681 · Sao Paulo, BrazilNTSB MIA01LA044Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hilton Head Isl, SCthe pilot's improper inflight planning/decision and failure to follow the prelanding checklist, resulting in the landing gear not being lowered in sufficient time to be verified down and locked, which resulted in a wheels up landing and substantial damage to…NTSB FTW01LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKthe certified flight instructor's (CFI) failure to maintain directional control of the airplane during landing. A contributing factor was the gusty wind condition.NTSB DEN01LA029Accident · No injuriesLimited investigationFinal reportCessna 172E · Salt Lake City, UTthe lack of suitable terrain for a forced landing. A factor was a total power loss due to a connecting rod failure.NTSB DEN01FA028Accident · 2 fatalField investigationFinal reportCessna 172 · Lusk, WYthe pilot's VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance, which resulted in an in-flight collision with terrain. Contributing factors were the pilot's failure to obtain a weather briefing, low…