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 MIA92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Panama City, FLThe pilot-in-command's failure to stand clear of the propeller as he rotated it by hand, resulting in the propeller rotating around due to engine compression, striking the pilot, causing him to lose his balance and fall to the ramp, resulting in serious…NTSB LAX92LA315Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Carlsbad, CAThe student pilot's failure to maintain adequate rotor RPM during a simulated engine failure, and the flight instructor's inadequate supervision of the flight.NTSB FTW92LA194Accident · No injuriesLimited investigationFinal reportCessna 172L · Ozona, TXThe pilot's failure to maintain obstacle clearance.NTSB FTW92LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · N. Little Rock, ARThe pilot's inadvertent entry into a stall.NTSB FTW92LA190Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Clovis, NMEngine failure due to improper oil filter installation and subsequent improper aircraft control by the PIC which resulted in a stall. A factor was maintenance inspection not performed after the oil filter installation.NTSB FTW92LA188Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Carrollton, TXThe pilot's selection of unsuitable terrain. Factors were the failed carburetor de-ice system valve resulting in an inoperative carburetor and the inadequate annual inspection by company maintenance personnel.NTSB CHI92FA211Accident · 2 fatalField investigationFinal reportStinson 108-3 · Boonville, MOInadequate preflight planning, and exceeding the performance capability of the airplane by the pilot-in-command.NTSB BFO92LA117Accident · No injuriesLimited investigationFinal reportRobinson R22A · Sanford, METhe pilot's selection of unsuitable terrain to execute a landing.NTSB ATL92LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Southport, NCThe failure of the pilot to maintain clearance from obstacles. A factor was the dusk lighting condition.NTSB SEA92LA162Accident · No injuriesLimited investigationFinal reportKaman HH-43F · Headquarters, IDFuel exhaustion and the pilot in command's delay in refueling.NTSB SEA92FA161Accident · 1 fatalField investigationFinal reportCessna 172I · Donnelly, IDThe pilot's failure to maintain airspeed after takeoff while using improper obstacle takeoff procedures. Factors include excessive flap extension.NTSB FTW92DPG10Accident · No injuriesFinal reportRockwell S2R-R3S · Minturn, ARThe loss of engine power and the encounter with unsuitable terrain during the forced landing.NTSB DEN92LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200R · Nederland, COA partial loss of power for undetermined reasons. A factor was: no suitable terrain for a forced landing.NTSB DEN92FA077Accident · 1 fatalField investigationFinal reportCessna 172RG · Fairplay, COThe flight instructor's operation at an altitude insufficient to clear obstacles in rising mountainous terrain. Factors were: high density altitude, diversion of the instructor's attention, and the rising terrain.NTSB BFO92LA115Accident · Minor injuriesLimited investigationFinal reportGeorge A Chaffee Kitfox II · Shelburne, VTThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing was the pilot's diverted attention to an open door, and an inadequate preflight inspection.NTSB ATL92LA144Accident · No injuriesLimited investigationFinal reportMooney M20G · Hendersonville, NCThe pilot's delay in executing a recovery from the bounced landing and his inadvertent stall during the initial climb after and landing was aborted. Factors were the excessive landing speed and the high density altitude.NTSB ANC92LA111Accident · No injuriesLimited investigationFinal reportCessna 180 · Wrangell, AKAn inoperative tailwheel.NTSB FTW92LA187Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Midland, TXA loss of control for reasons undetermined.NTSB DEN92FA076Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Manville, WYA loss of control following flight into weather conditions containing thunderstorms, turbulence and icing conditions. Factors were: inaccurate weather evaluation and flight into known adverse weather by the pilot in command.NTSB BFO92LA111Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Charleston, WVThe pilot's failure to attain adequate airspeed to outclimb obstacles.NTSB BFO92FA109Accident · 2 fatalField investigationFinal reportBeech 58 · Denver, PAThe pilot's loss of aircraft control due to spatial disorientation. The weather conditions were factors that contributed to the accident.NTSB ATL92LA143Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Eufaula, ALThe failure of the fuel injector servo as a result of the sticking bushing between the diaphragms.NTSB ANC92LA110Accident · No injuriesLimited investigationFinal reportCessna 172 · Twin Hills, AKThe pilot in command not following the procedures outlined in the pilot's operating handbook.NTSB SEA92FA160Accident · 1 fatalField investigationFinal reportCessna 172P · Kingston, WAThe pilot's attempt to conduct VFR flight in instrument meteorological conditions. Factors include fog and low ceilings.NTSB LAX92LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Las Vegas, NVThe failure of the maintenance personnel to safety the engine oil drain plug and the poor engine overhaul. Factors relating to this accident are: oil starvation; the failure of the connecting rods; the incorrect connecting rod bolts; and the connecting rod…NTSB LAX92LA311Accident · No injuriesLimited investigationFinal reportCessna 172 · Elko, NVThe pilot's failure to maintain adequate altitude over the terrain, and his failure to maintain sufficient airspeed. The mountainous terrain was a factor.NTSB LAX92LA310Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sierraville, CAThe pilot's inadequate preflight of the aircraft. The contaminated fuel system and the rough terrain were factors in the accident.NTSB LAX92FA313Accident · 3 fatalField investigationFinal reportBeech 23 · Fall River Mill, CAThe pilots decision to turn down wind at a critical phase of the go around with inadequate airspeed resulting in a stall mush uncontrolled descent. Contributing to the accident was the unfavorable wind conditions and a stabilator interference caused by a…NTSB FTW92LA185Accident · No injuriesLimited investigationFinal reportBeech D55 · Pineville, LAThe mechanical binding of the yoke after liftoff.NTSB FTW92LA183Accident · No injuriesLimited investigationFinal reportCessna 180K · Curlew Island, LAThe pilot's selection of unsuitable terrain for landing. A factor was the pilot's physical impairment.NTSB CHI92DEM04Accident · Serious injuriesFinal reportHauser, William C. Cassutt · Winn, MIThe ditch the airplane encountered during the landing roll phase of a forced landing.NTSB BFO92LA112Accident · No injuriesLimited investigationFinal reportJames Snyder Challenger II · Burlington, CTThe loss of engine power for undetermined reasons.NTSB BFO92LA110Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Belmont, NHInadequate in-flight planning/decision by the pilot.NTSB ATL92LA141Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Americus, GAA loss of engine power due to a crack in the number three cylinder. A factor was the soft terrain at the forced landing area.NTSB ANC92LA109Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Mcgrath, AKThe fire in the engine accessory drive assembly. Factor was the rough an uneven forced landing area.NTSB SEA92LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Provo, UTFuel exhaustion due to inadequate fuel supply. Factors include a ditch encountered while landing.NTSB SEA92LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Burley, IDFuel exhaustion when anticipated fuel consumption was not adequately calculated.NTSB DEN92IA074Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 RT · Denver, COOpen air ground circuit breakers that allowed the propellers to overspeed. A factor was: clear air turbulence.NTSB ATL92LA142Accident · No injuriesLimited investigationFinal reportCessna A185F · Maxton, NCThe pilot's inadequate compensation for wind condition and the pilot-in-command's inadequate supervision of the pilot in training.NTSB ANC92T#A06Accident · No injuriesClass 3Final reportCessna 206 · Bethel, AKNTSB SEA92LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Twin Falls, IDThe pilot's failure to refuel resulting in fuel exhaustion and the unsuitable terrain encountered during the forced landing.NTSB LAX92LA309Accident · No injuriesLimited investigationFinal reportPiper PA32-301T · Van Nuys, CAAn on ground collision with terrain subsequent to an engine failure for undetermined reasons.NTSB BFO92LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Marston Mills, MAThe pilot's inadequate preflight preparation. Contributing was the pilot's failure to use all available runway and overconfidence in his own abilities.NTSB BFO92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Norwalk, OHLoss of engine power due to undetermined reasons and the lack of suitable terrain for a forced landing.NTSB BFO92LA106Accident · No injuriesLimited investigationFinal reportHaas Rans S-6 · Nokesville, VAImproper planning or decision by the pilot, and his failure to maintain clearance from obstructions after inadvertently becoming airborne. The high density altitude, high obstructions, and the pilot's lack of familiarity with the airplane were related factors.NTSB ANC92LA108Accident · No injuriesLimited investigationFinal reportCessna 207 · Dillingham, AKThe pilot in command's failure to maintain visual lookout and clearance from terrain. A factor was the pilot diverted his attention to secure a loose fire extinguisher.NTSB MIA92LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Ft Walton Beach, FLThe pilot misjudged his altitude while turning on final approach over water to land at an airport.NTSB LAX92LA308Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tucson, AZThe pilot's poorly planned approach and failure to attain the proper descent rate. The loss of engine power for undetermined reasons and the rough terrain conditions in the area of the forced landing were factors in the accident.NTSB LAX92LA306Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Kernville, CAThe pilot's selection of the wrong runway; poorly planned approach; failure to attain the proper touch down point; and delay in executing the go-around. Contributing to this accident was the existing tailwind and crosswind.NTSB LAX92FA305Accident · 4 fatalField investigationFinal reportCessna 175A · Overgaard, AZThe pilot's improper preflight performance planning and decision to operate the airplane over the maximum certified gross weight at a high density altitude airport which resulted in an inadvertent stall. Contributing to the accident was inadequate maintenance…