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 LAX90LA267Accident · No injuriesLimited investigationFinal reportCessna 150J · Jamul, CAThe pilot's delay in applying carburetor heat.NTSB LAX90FA268Accident · No injuriesField investigationFinal reportBell 206B · Quincy, CAAn unidentified contaminate lodged in the fuel governor.NTSB LAX90DVG17Accident · Minor injuriesFinal reportCloutier Scorpion 133 · Oroville, CAThe pilot's loss of directional control.NTSB FTW90LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Lytle, TXThe pilot's failure to adequately manage the onboard fuel supply.NTSB FTW90DRD14Accident · 1 fatalFinal reportGrumman G-164A · Sommerset, LAThe pilot's failure to attain adequate clearance above crops at the end of the runway.NTSB CHI90FA196Accident · No injuriesField investigationFinal reportCessna 172 · Canton, MIThe pilot's inadequate takeoff procedure, premature liftoff and delayed reaction to abort the takeoff.NTSB CHI90FA193Accident · 2 fatalField investigationFinal reportPiper PA-38 · Hinckley, ILThe instructor pilot's inability to recover from a stall/spin. Factors were: acft wt & balance exceeded, and the instructor's and student pilot's lack of familiarity with acft.NTSB ANC90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big River, AKThe improper use of brakes by the pilot during the landing roll.NTSB SEA90LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Jordan, MTPilot's failure to switch fuel tanks and the unsuitable terrain available for a forced landing.NTSB SEA90LA143Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Redmond, ORThe student pilot's failure to properly recover from a bounced landing.NTSB MIA90LA158Accident · Minor injuriesLimited investigationFinal reportBell 206B · Sarasota, FLImproper control input after the loss of tail rotor effectiveness.NTSB LAX90FA265Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Apple Valley, CAImproper preflight planning/decision by the pilot. Factors related to the accident were: failue of the pilot to configure the aircraft's flaps for a soft field takeoff, his improper use of stabilator trim, high density altitude, soft runway, and trees near…NTSB CHI90LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · East Tawas, MIThe private pilot's failure to maintain adequate control of the aircraft after touchdown.NTSB NYC90FA169Accident · Serious injuriesField investigationFinal reportDavid B. Robertson VARI-EZE · Cincinnati, OHA power loss due to improper installation of a fuel line fitting and inadequate maintenance and inspection.NTSB FTW90LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24 · West Fork, ARThe catastrophic failure of the engine.NTSB DEN90DTE04Accident · 2 fatalFinal reportOlsen Pursuit · Fowler, COFailure of the pilot to maintain adequate airspeed on final approach to land, which resulted in an inadvertent stall. A factor relate to the accident was: the pilot's physical impairment from carbon monoxide.NTSB CHI90LA207Accident · No injuriesLimited investigationFinal reportAircoupe F-1 · Washington, MOFailure of the other aircraft's pilot to maintain an adequate visual lookout prior to turning to final. A factor in the accident was the restricted visual lookout for this aircraft's pilot.NTSB CHI90LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Twining, MIThe pilot's inability to maintain adequate control of the aircraft as it decellerated on the runway after touchdown.NTSB CHI90FA190Accident · 3 fatalField investigationFinal reportPiper PA-28 · Plymouth, MIInadequate visual lookout by the pilot of the PA-60. A factor related to the accident was that neither of the flight crews had obatained atc/radar assistance.NTSB CHI90DCG01Accident · Serious injuriesFinal reportGeorge R. Losey J6-KARATOO · Grain Valley, MOThe propeller blade separation during initial climb, and the failure of the pilot in command to maintain flying speed during the emergency descent.NTSB ATL90LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Sanford, NCThe failure of the no.1 piston, for undetermined reasons, which resulted in a complete loss of engine power. A factor to the accident was, the forced landing in a soft field.NTSB NYC90LA170Accident · No injuriesLimited investigationFinal reportCessna 340A · Prospect, PAAn on ground collision with terrain after the right main landing gear side brace failed due to shear from the soft, wet, rough runway, allowing the right main landing gear to collapse.NTSB NYC90LA057Accident · Serious injuriesLimited investigationFinal reportCameron AX-8 · Schodack, NYThe inflight encounter with unforecast high winds.NTSB FTW90LA144Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Terrell, TXWrong runway selected by second pilot. Factors were: tailwind and inadequate supervision by pilot-cfi.NTSB FTW90DRD13Accident · 1 fatalFinal reportde Havilland DH-82A · Youngsville, LAThe pilot's failure to touch down at the proper point on the landing surface. A contributing factor was the late initiation of the aborted landing.NTSB ATL90FA146Accident · Minor injuriesField investigationFinal reportBoeing 737-222 · Kinston, NCFailure of the fuel pump control shaft because of improper machining by the repair facility during maintenance modification of the pump and improper procedures during overhaul of the nose landing gear.NTSB SEA90LA145Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Missoula, MTPilot's failure to maintain directional control during the landing roll.NTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.NTSB NYC90LA168Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Gt. Barrington, MAThe pilot's failure to maintain adequate clearance from tree during the precautionary landing. Factor was a loss of thermal lift.NTSB MIA90LA157Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Plant City, FLEngine failure for undetermined reasons resulting in the forced landing.NTSB MIA90LA156Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Jensen Beach, FLFuel exhaustion due to improper planning by the pilot.NTSB LAX90LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Clarksburg, CAThe failure of the airplane's muffler during initial climb.NTSB LAX90DVG13Accident · Serious injuriesFinal reportCharles T. Brietigam RV-4 · San Andreas, CAThe failure of four propeller retention bolts which required the engine to be shut down. A factor in the accident was the pilot's misjudgement of the forced landing approach.NTSB FTW90LA143Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350D · Berwick, LAPilot in command's failure to see and avoid obstacles in the landing zone. Contributing to the accident was the pilot's lack of familiarity with the landing zone.NTSB FTW90DRA07Accident · 1 fatalFinal reportBensen B-8M · Hearne, TXThe pilot's loss of control in flight due to excessive control inputs and his abrupt attempts to recover control of the aircraft prior to impact.NTSB CHI90DEE08Accident · No injuriesFinal reportRonald D. Cothern Quickie · Plainfield, ILSeparation of an ignition lead, resulting in loss of engine power. A factor in the accident was the pilot's inadequate preflight inspection.NTSB ANC90LA122Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Louise, AKThe pilot's failure to maintain directional control during landing. A contributing factor was a crosswind.NTSB LAX90LA262Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Long Beach, CAThe pilot's improper planning/decision, which resulted in fuel exhaustion.NTSB LAX90LA261Accident · No injuriesLimited investigationFinal reportCessna 180B · Red Bluff, CAAn improper landing flare and improper recovery from the bounced landing.NTSB LAX90FA260Accident · 1 fatalField investigationFinal reportBeech B36TC · Santee, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions, and his loss of control due to spatial disorientation. Factors contributing to the accident were: the pilot's failure to obtain a weather briefing, the existing weather…NTSB LAX90DVG12Accident · Serious injuriesFinal reportE.J. Novotny Steen Skybolt · Fall River Mill, CALoss of power for undetermined reasons.NTSB FTW90DRA06Accident · Minor injuriesFinal reportHuffaher Benson · Hearne, TXThe pilot's failure to adequately compensate for the tail wind condiitons during a low pass which exceeded the performance capability of the aircraft. A factor was the tail wind conditions.NTSB CHI90LA179Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOInadequate visual outlook by the PIC.NTSB SEA90LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Island Park, IDImproper planning/decision by the pilot. The high density altitude and the pilot's overconfidence in the aircraft's ability were related factors.NTSB NYC90LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hudson, NYThe failure of the pilot to maintain directional control during a rejected landing. Factors related to the accident were: improper use of the flight controls by the pilot, a variable wind, and lack of expereince in type of airplane.NTSB FTW90LA142Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Worth, TXPilot's failure to maintain directional control. Contributing to the accident was the pilot's diverted attention.NTSB CHI90LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Graceton, MNVso airspeed not maintained and stall encountered by the pilot in command/cfi.NTSB CHI90LA183Accident · No injuriesLimited investigationFinal reportCessna 180 · Orr, MNThe pilot's failure to perform fuel consumption calculations which resulted in fuel exhaustion and subsequent loss of engine power. Factor was rough/uneven terrain.NTSB CHI90LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe instructor's inability to control the airplane during its landing roll.NTSB CHI90IA181Incident · No injuriesIncident investigationFinal reportBell 206A · Lake Ozark, MOCompression assembly blade and emergency floatation gear failure.