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 LAX92LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Compton, CAThe improper maintenance of the alternator's drive belt by the aircraft owner which resulted in its total failure. A factor which contributed to the accident was the inadequate distance available for the pilot to stop the airplane.NTSB SEA92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Monticello, UTInadequate maintenance/overhaul of the engine, and subsequent failure of the #5 piston (hole burned in piston), due to pre-ignition and/or detonation. Rough/uneven terrain in the emergency landing area was a related factor.NTSB NYC92LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S-60 · Trenton, NJExcessive descent rate by the pilot in command. A factor was overloading of the basket.NTSB NYC92LA011Accident · No injuriesLimited investigationFinal reportAerospatiale ND-26 · Albany, NYInadequate quality control during maintenance or manufacturing by failing to use corrosion inhibiter, which resulted in corrosion, fatigue, and subsequent failure.NTSB LAX92LA021Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Fremont, CAThe pilot's inadequate altitude on final approach.NTSB LAX92LA020Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · Chandler, AZAn engine malfunction produced by exhaust valves stuck in the open position. Contributing to the accident was an unsuitable landing area and a sign adjacent to the landing area.NTSB FTW92LA018Accident · Minor injuriesLimited investigationFinal reportMahan Hardaway Quickie Q2 · Arcola, TXThe pilot's improper flare and improper recovery from the resultant bounced landing. A factor was the pilot's lack of familiarity with the airplane.NTSB FTW92LA012Accident · No injuriesLimited investigationFinal reportNorth American Navion · Denison, TXThe exceeding of the airplane's takeoff performance capability by the pilot's inadequate preflight preparation..NTSB CHI92LA015Accident · No injuriesLimited investigationFinal reportNorth American Navion D · Lake Geneva, WIFatigue failure of the crankshaft. A factor in the accident was inadequate quality control by other maintenance personnel.NTSB CHI92LA014Accident · No injuriesLimited investigationFinal reportCessna C-210G · Freeport, ILImproper installation of a line fitting by other maintenance personnel.NTSB ATL92LA015Accident · No injuriesLimited investigationFinal reportBellanca 8JCAB · Morristown, TNThe pilot's failure to maintain a proper altitude during a low pass. A factor in this accident was the pilot's overconfidence in his personal ability.NTSB NYC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Edgartown, MAImproper recovery from a bounced landing by the pilot. Factors related to the accident were improper use of the flight controls and throttles.NTSB NYC92LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Montgomery, NYFailure of the pilot-in-command to correctly position the fuel selector when the right main fuel tank was exhausted, resulting in fuel starvation to the engine.NTSB NYC92LA010Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Webster, NHFailure of the ground crewman (from another Balloon) to recognize the hazardous condition that existed, when the Balloon came in contact with a high voltage power line during a precautionary landing. Factors related to the accident were: the lack of suitable…NTSB MIA92LA015Accident · No injuriesLimited investigationFinal reportRockwell 685 · Tupelo, MSThe pilot in commands failure to insure that adequate fuel was placed on the aircraft for the flight resulting in loss of power in both engines due to fuel exhaustion.NTSB CHI92LA096Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Goshen, INAn improper touchdown by the pilot in command.NTSB CHI92FA013Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Lafayette, INFailure of the pilot to compensate for wind conditions during initial climb. Factors associated with the accident are crosswind conditions and a dark night light condition.NTSB BFO92LA002Accident · No injuriesLimited investigationFinal reportCessna 177B · London, KYThe loss of engine power from fuel starvation due to inadequate inflight planning/decision by the pilot.NTSB ATL92LA012Accident · Serious injuriesLimited investigationFinal reportDon Jackman Pitts S-1S · Franklinville, NCThe failure of the pilot to maintain proper clearance from the power line.NTSB ATL92LA011Accident · No injuriesLimited investigationFinal reportWinchester Thorp T-18 · Walterboro, SCThe student pilot's improper use of the wheel brakes, and the subsequent loss of directional control. Factors in this accident were the student pilot's lack of total flying experience and the pilot-in-command's inadequate supervision of the flight.NTSB ANC92FA006Accident · No injuriesField investigationFinal reportBeech BE-99 · Allakaket, AKWas the pilot-in-command misjudged the proper touchdown point on the runway. Contributing to the accident was the snow-covered terrain and a snowbank.NTSB SEA92FA013Accident · 3 fatalField investigationFinal reportCessna 172N · Columbus, MTThe pilot in command's operation at too low an altitude over the river and his failure to maintain adequate clearance from the power lines. Factors contributing to the accident were the wires crossing the river and the pilot in command's poor judgement in…NTSB NYC92LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, METhe failure of the nose wheel through bolt as a result of fatigue cracking.NTSB NYC92LA013Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov Lark I-28-B2 · Blairstown, NJAn improperly planned approach which resulted in an inadvertent stall with insufficient altitude for recovery. A factor related to the accident was improper use of the flight controls by the pilot.NTSB LAX92LA019Accident · 1 fatalLimited investigationFinal reportCessna 120 · Olancha, CAFailure of the pilot to maintain adequate airspeed resulting in an inadvertent stall while on final approach. Factors were the high density altitude and the pilot's poor approach planning.NTSB CHI92LA016Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Warsaw, INPilot's delayed inflight planning/decision to land.NTSB CHI92DEP01Accident · No injuriesFinal reportLassiter Swearingen SX300 · Eagle River, WIThe partial loss of engine power, for reasons undetermined which resulted in an aborted takeoff and eventual overrun and landing gear collapse.NTSB BFO92LA001Accident · No injuriesLimited investigationFinal reportCessna 150H · Saluda, VAThe pilot's decision to abort the takeoff with inadequate runway to stop. A factor in the accident was the failure of the exhaust muffler baffle.NTSB ANC92LA007Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Scammon Bay, AKThe pilot's failure to maintain airspeed during the aborted landing. Contributing to the accident was the unfavorable wind.NTSB SEA92T#A01Accident · 2 fatalClass 3Final reportLockheed P-3A · Florence, MTNTSB NYC92FA009Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas MD-80 · Newark, NJFailure of the crew of the B-737, N7385F, to maintain adequate visual lookout while taxiing, and failure by air traffic controllers to provide traffic information and/or issue warnings to either flightcrew. A factor was the after-landing task saturation of…NTSB LAX92LA018Accident · No injuriesLimited investigationFinal reportSnow S2C · Bowie, AZThe failure of the pilot to maintain directional control after landing. The unfavorable wind condition was a related factor.NTSB FTW92IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Houston, TXThe pilot's failure to attain proper runway alignment prior to touchdown and his failure to initiate a go around to remedy the situation. A factor was the low altitude at which he initiated the side step maneuver for which he was cleared.NTSB FTW92GA011Accident · No injuriesFinal reportCessna T21OR · Lordsburg, NMThe pilot's improper recovery from a bounced landing. Factors were the pilot's excessive airspeed and improper flare technique.NTSB CHI92LA011Accident · No injuriesLimited investigationFinal reportCessna 152 II · Lee'S Summit, MOThe student pilot's failure to maintain directional control. Related factors are the student's lack of total experience, improper touch and go procedures, and diverted attention.NTSB CHI92LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Maple Lake, MNThe loss of engine power for an undetermined reason.NTSB ATL92LA010Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Selma, ALThe fatigue failure of the engine crankshaft counterweight blade, which resulted from excessive wear of the counterweight pin bushings, due to corrosion from an unknown source.NTSB ATL92LA009Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Whitesburg, GAA sudden wind shift during initial climb which resulted in an uncontrolled descent.NTSB ANC92LA008Accident · No injuriesLimited investigationFinal reportCessna A185E · Dog Salmon Riv, AKThe pilot's failure to maintain airspeed. Contributing to the accident was the downdraft.NTSB SEA92FA222Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Moran, WYThe pilot's failure to maintain clearance and altitude from terrain while maneuvering, and his failure to adequately compensate for the wind conditions. Factors contributing to the accident are terrain-induced turbulence, unfavorable winds, gusty high winds,…NTSB CHI92LA012Accident · No injuriesLimited investigationFinal reportRockwell 112YC · Detroit, MIThe pilot's failure to perform a major repair and continued operation of the airplane with known deficiencies.NTSB ATL92FA008Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Spring Lake, NCThe inadvertent flight from visual flight rules flight conditions into instrument flight rules flight conditions by the non-instrument rated pilot, and his subsequent failure to maintain control of the aircraft.NTSB ANC92FA005Accident · Minor injuriesField investigationFinal reportPiper PA-18 · Montague Island, AKThe power loss due to the crankshaft failure. Contributing to the accident was improper maintenance during the last engine overhaul.NTSB LAX92LA016Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Reno, NVA partial loss of engine power for undetermined non-mechanical reasons.NTSB LAX92LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Linden, CAThe pilot in command inaccurately calculating the aircraft's fuel consumption, and not re-fueling the aircraft prior to takeoff from his last departure point. This resulted in a power loss due to fuel exhaustion. A factor in this accident was the unsuitable…NTSB CHI92LA010Accident · No injuriesLimited investigationFinal reportMooney M20K · Knox, INThe overload failure of the #2 cylinder connecting rod. Contributing to the accident was the night light conditions and the pilot's inability to reach a suitable landing area.NTSB SEA92LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA28-161 · Duchesne, UTFuel exhaustion due to the pilot's inattention and becoming lost. A factor to the accident was the night conditions.NTSB SEA92LA008Accident · No injuriesLimited investigationFinal reportMcholland XPA-11 · Sandpoint, IDA poor in-flight decision. Contributing to the accident was the rough/uneven terrain.NTSB SEA92LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA24-180 · Marysville, WAThe slippage of the accessary drive gear due to improper maintenance by other maintenance personnel. Factors include a forced landing in unsuitable terrain.NTSB SEA92LA006Accident · Minor injuriesLimited investigationFinal reportCessna C-150M · Woodburn, ORA seized engine exhaust valve. Factors include rough terrain and a collapsed nose gear.