NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 CEN22FA433Accident · 1 fatalClass 3 · FieldFinal reportAirgyro AG915 · Yankton, SDA loss of control while an in-flight fire occurred, which resulted in an impact with terrain. Contributing to the accident was the pilot/builder’s improper engine build procedures.NTSB WPR22LA359Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Mesa, AZThe flight instructor’s failure to maintain control of the helicopter’s rate of descent, resulting in a hard landing.NTSB WPR22LA356Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Superior, MTThe pilot’s excessive airspeed during a landing, which resulted in a runway overrun and collision with terrain.NTSB ERA22LA435Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Clearwater, FLThe pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA22LA434Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Augusta, GAThe failure of the nose landing gear to fully extend and lock into position for reasons that could not be determined, which resulted in its collapse during landing.NTSB CEN22LA439Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop.NTSB WPR22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lyman, WAThe pilot’s delayed decision to exit the valley with rising terrain and failure to maintain clearance from trees.NTSB WPR22LA355Accident · Minor injuriesClass 4 · LimitedFinal reportHartunian Robert Pulsar XP · Big Bear, CAThe pilot’s inability to maintain directional control after landing with an excessive ground speed due to a tailwind which, resulted in a severe shimmy which subsequently damaged a hydraulic brake line.NTSB ERA22LA436Accident · No injuriesClass 4 · LimitedFinal reportPiper PA60 · Richmond, KYThe pilot’s failure to extend the landing gear prior to landing.NTSB DCA22WA213Incident · No injuriesClass 5 · ForeignBoeing 737 · Panama City, PanamaNTSB CEN22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportHibbard Norman E Thorp T-18 · Del Norte, COThe pilot’s loss of airplane control during landing due to a wind gust.NTSB ANC22LA080Accident · 1 fatalClass 3 · LimitedFinal reportCessna 180A · Skwentna, AKThe failure of the landing gear float due to inadequate maintenance of the floats and corrosion.NTSB GAA22WA291Accident · 1 fatalClass 5 · ForeignChallenger II · Rideau-Ontario, CanadaNTSB ERA23LA003Accident · Serious injuriesClass 4 · LimitedFinal reportDestiny XLT · Oneonta, ALThe uncertificated pilot’s failure to maintain control of the powered parachute during takeoff.NTSB ERA22LA430Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Buffalo, NYThe pilot’s failure to maintain aircraft control during initial climb after a go-around, which resulted in an aerodynamic stall and spin at low altitude.NTSB DCA22WA209Accident · Minor injuriesClass 4 · ForeignBoeing 737 · Montpellier, FranceNTSB CEN22LA430Accident · No injuriesClass 3 · LimitedFinal reportAgusta AW139 · Houma, LAThe inflight loss of collective control of the helicopter due to thermal damage of a collective control torque tube that abraded with misrouted electrical wiring, which resulted in an electrical short and inflight fire. Contributing to the accident were the…NTSB WPR22LA358Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · South Jordan, UTThe pilot’s inability to see and avoid a bird while landing in dark night conditions.NTSB GAA22WA301Accident · 2 fatalClass 5 · ForeignWagaero Sportsman · Champais, Quebec, CanadaNTSB ENG22WA046OccurrenceClass 5 · ForeignATR ATR72 · Vicinity of Sárvár, HungaryNTSB ANC22LA081Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Chignik Lake, AKThe pilot’s failure to maintain airplane control during taxi in gusty conditions, which resulted in a nose-over and substantial damage to the rudder and wings.NTSB WPR22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Sisters, ORThe non-instrument-rated pilot’s flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s degraded judgement due to fatigue.NTSB GAA22WA317Accident · No injuriesClass 4 · ForeignPiper PA38 · Jujuy, ArgentinaNTSB GAA22WA305Accident · No injuriesClass 5 · ForeignCessna C172 · Yao, JapanNTSB ERA22LA428Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Cincinnati, OHThe airplane builder’s installation of incorrect hardware in the control yoke assembly, which resulted in a loss of control during takeoff.NTSB DCA22LA212Incident · No injuriesClass 3 · LimitedFinal reportAirbus A330-243 · Los Angeles, CAUncommanded movement of the trimmable horizontal stabilizer control wheel for reasons that could not be determined based on the available evidence.NTSB CEN22LA429Accident · No injuriesClass 3 · LimitedFinal reportCommander 114TC · Savoy, TXA loss of engine power for reasons that could not be determined.NTSB GAA22WA300Accident · 1 fatalClass 5 · ForeignEmbraer EMB720 · Santa Cruz, BoliviaNTSB GAA22WA290Accident · 1 fatalClass 5 · ForeignMeriwether Jon Arion Lightning · Kenora, CanadaNTSB ERA22LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Ocean City, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind, resulting in the runway excursion and nose over.NTSB ERA22LA427Accident · 1 fatalClass 3 · LimitedFinal reportNorthwing Design Apache Sport · Southern Shores, NCA loss of aircraft control due to movement of the outer portion of the right wing fabric and displacement of wing ribs for reasons that could not be determined based on the available information.NTSB WPR22LA353Accident · No injuriesClass 3 · LimitedFinal reportCessna 525B · Pasco, WAThe failure of the pilot to ensure the landing gear was extended before landing. Contributing was the pilot’s failure to fly a stabilized approach, and his configuration of the airplane that prevented activation of the landing gear not extended warning system…NTSB DCA22WA208Accident · 1 fatalClass 5 · ForeignBAE 3201EP · San Antonio del Estrecho, PeruNTSB CEN22LA426Accident · No injuriesClass 4 · LimitedFinal reportMossman Michael D Zenair CH 601 HD · Lebanon, INThe loss of lateral/bank control during takeoff due to the pilot’s decision to operate the airplane with a known fuel imbalance.NTSB WPR22LA362Accident · No injuriesClass 4 · LimitedFinal reportAngus Watt Zenair Stolch 750 · Howe, IDThe pilot’s failure to maintain adequate airspeed during the landing approach, which resulted in an aerodynamic stall.NTSB GAA22WA288Incident · No injuriesClass 5 · ForeignCessna 172 · Donji Proložac, CroatiaNTSB GAA22WA285Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Chinchilla, AustraliaNTSB ERA22FA426Accident · 2 fatalClass 3 · FieldFinal reportChampion Aeronca 7AC · Bridgeton, NJThe pilot's exceedance of the airplane’s critical angle of attack shortly after takeoff, which resulted in an aerodynamic stall, loss of control, and impact with terrain.NTSB ENG22WA045Incident · No injuriesClass 5 · ForeignATR ATR72 · Belfast, United KingdomNTSB DCA22WA205OccurrenceClass 5 · ForeignBeech 1900 · Brazzaville, Congo - KinshasaNTSB ANC22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 · Egegik, AKThe pilot’s loss of control during takeoff in gusting wind conditions.NTSB WPR22FA350Accident · 1 fatalClass 3 · FieldFinal reportAerovodochody L-29 Delfin · Reno, NVThe pilot’s in-flight incapacitation due to G-induced loss of consciousness, which resulted in a subsequent impact with terrain.NTSB GAA22WA287Accident · 2 fatalClass 5 · ForeignCessna 172 · Shaunavon, CanadaNTSB ERA22LA425Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Great Barrington, MAThe student pilot's inadvertent movement of the fuel selector to the OFF position, which resulted in fuel starvation and a total loss of engine power.NTSB ANC22LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Tok, AKThe pilot’s improper application of the brakes, which resulted in a nose-over and substantial damage to the rudder and wings.NTSB GAA22WA297AccidentClass 5 · ForeignDan Hawken Titan T-51 · Soest, GermanyNTSB GAA22WA289Accident · 2 fatalClass 5 · ForeignEvektor EV97 · Sesso, Reggio Emilia, ItalyNTSB ERA22LA424Accident · Minor injuriesClass 3 · LimitedFinal reportRockwell International 700 · Sevierville, TNThe total loss of engine power to the twin-engine airplane during final approach due to fuel exhaustion. Contributing to the accident was the pilot’s failure to maintain aircraft control during the approach to land, which resulted in a runway excursion and…NTSB ERA22FA422Accident · 2 fatalClass 3 · FieldFinal reportWren Ronnie D Titan II · Citra, FLThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain airspeed while recovering from an aerobatic maneuver, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s use of…NTSB CEN22LA425Accident · No injuriesClass 4 · LimitedFinal reportSlipstream Revelation · Delphi, INA loss of engine power due to carburetor icing.