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 GAA22WA148Accident · 3 fatalClass 5 · ForeignVans RV10 · Chubut, ArgentinaNTSB GAA22WA147Accident · 1 fatalClass 4 · ForeignHughes 369 · Port McNeil, CanadaNTSB ERA22LA183Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Waterville, METhe student pilot’s incorrect landing flare, which resulted in a hard bounced landing and nose landing gear collapse.NTSB ERA22LA210Accident · No injuriesClass 4 · LimitedFinal reportHenderson Clifford S Super Bear CSH-1 · Indiana, PAThe pilot's loss of directional control while landing, which resulted in a ground loop.NTSB ENG22WA021IncidentClass 5 · ForeignSaab 340 · South Melbourne, AustraliaNTSB DCA22WA107IncidentClass 5 · ForeignBoeing 777 · Paris, FranceNTSB CEN22LA167Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Hawley, TXThe pilot’s poor decision to exit the helicopter with the engine and main rotor still operating.NTSB CEN22FA168Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Marlin, TXThe pilot’s failure to maintain control of the airplane during landing for reasons that could not be determined based on available information.NTSB GAA22WA144Accident · 2 fatalClass 5 · ForeignBell 206 · Adaminaby, AustraliaNTSB ERA22LA179Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Manville, NJThe pilot’s delayed go-around decision following an encounter with a tailwind during landing, which resulted in an inability to climb and subsequent impact with trees.NTSB ENG22WA027Incident · No injuriesClass 3 · ForeignDe Havilland DHC2 · Moruya, AustraliaNTSB WPR22LA142Accident · Serious injuriesClass 3 · LimitedFinal reportBarber Robert L Sonerai II L · Jean, NVA reported loss of engine power for undetermined reasons.NTSB GAA22WA153Accident · 1 fatalClass 5 · ForeignAgusta AW139 · Iwaizumi, JapanNTSB ENG22LA020IncidentClass 3 · LimitedFinal reportBombardier BD-700-2A12 · West Palm Beach, FLAn in-flight engine fire resulted from a fuel leak from fuel nozzle No. 16 pigtail-to-fuel manifold b-nut connection that contacted hot engine parts and ignited. Contributing to the manifold fuel leak was the misalignment between fuel manifold female ferrule…NTSB DCA22WA159IncidentClass 5 · ForeignBoeing 737-800 · Tawau, MalaysiaNTSB DCA22WA117IncidentClass 5 · ForeignBoeing 737 · Kuala Lumpur, MalaysiaNTSB CEN22LA170Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Houston, TXThe student pilot’s failure to maintain direction control during takeoff in gusty wind conditions.NTSB CEN22LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Pearland, TXThe flight instructor's failure to extend the landing gear and perform a before landing checklist.NTSB CEN22LA165Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Calhan, COThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB WPR22LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Van Nuys, CAThe student pilot’s failure to maintain sufficient distance behind a jet airplane which, resulted in his loss of airplane control due to the jet airplane’s jet blast and the flight instructor’s delayed remedial action.NTSB WPR22LA141Accident · No injuriesClass 4 · LimitedFinal reportFernandes Dale R Glasair II S-FT · Saline Valley, CAThe pilot’s failure to establish a controlled descent rate during landing which resulted in the airplane touching down short of the runway.NTSB GAA22WA142AccidentClass 5 · ForeignPiper PA-28R · Le Touquet, United KingdomNTSB ERA22LA180Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 269A · Fort White, FLThe non-instrument-rated pilot’s decision to fly a visual flight rules only helicopter in instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB ERA22LA177Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170 · Stoney Point, NCThe pilot’s failure to retract the flaps during a go-around from a bounced landing, which resulted in a collision with trees then terrain.NTSB ERA22LA176Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177RG · Gaithersburg, MDThe pilot’s failure to maintain adequate airspeed while maneuvering on final approach which resulted in a high sink rate and subsequent collision with a fence.NTSB ERA22LA175Accident · Minor injuriesClass 3 · LimitedFinal reportLearjet 45 · Morristown, NJThe captain’s inadequate compensation for crosswind conditions, which resulted in a loss of directional control.NTSB WPR22LA140Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Merced, CAThe pilot’s failure to see and avoid wires while conducting an aerial application flight, which resulted in a wire strike and ground impact.NTSB GAA22WA150Accident · No injuriesClass 5 · ForeignPiper PA11 · Miramar, ArgentinaNTSB ENG22LA049IncidentClass 3 · LimitedFinal reportBombardier Global 7500 · Riyadh, Saudi ArabiaAn in-flight engine fire resulted from a fuel leak from fuel nozzle No. 18 pigtail-to-fuel manifold b-nut connection that contacted hot engine parts and ignited. Contributing to the manifold fuel leak was the misalignment between fuel manifold female ferrule…NTSB DCA22WA108IncidentClass 5 · ForeignBoeing 737 · Madrid, SpainNTSB CEN22LA164Accident · 1 fatalClass 3 · LimitedFinal reportMooney M20E · Kerrville, TXThe pilot’s sudden cardiac event, which resulted in incapacitation, uncontrolled taxi after landing, and collision with a stationary parked airplane.NTSB CEN22LA163Accident · 2 fatalClass 3 · LimitedFinal reportKitfox 7 · Crowell, TXThe pilot's exceedance of the airplane's critical angle of attack during low-level flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB WPR22LA139Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Swan Valley, IDThe pilot’s failure to maintain airplane control during the landing roll on a snow-covered runway surface.NTSB WPR22LA138Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Michael E Cozy Mark IV · Tucson, AZThe total loss of engine power during an approach due to clogged fuel filters, which resulted from an epoxide sealant used in manufacture of the airplane deteriorating and clogging the fuel filter.NTSB GAA22WA310Incident · No injuriesClass 5 · ForeignPiper PA60 · Montevideo, UruguayNTSB GAA22WA140Accident · 1 fatalClass 5 · ForeignCessna 208 · Gruehorn, SwitzerlandNTSB GAA22WA137Accident · 3 fatalClass 5 · ForeignBeech C90A · Temixco, MexicoNTSB CEN22LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Lampasas, TXThe pilot’s decision to perform a takeoff from a perpendicular taxiway rather than the airport runway, which led to the airplane striking trees at the end of the departure path.NTSB GAA22WA138Accident · 1 fatalClass 5 · ForeignSachse Stephan Aventura II · Klekot, PolandNTSB ERA22LA178Accident · No injuriesClass 4 · LimitedFinal reportExtra 300 · Rome, GAAn inflight collision with a bird while conducting low level aerobatics.NTSB ERA22LA174Accident · Minor injuriesClass 4 · LimitedFinal reportFpna A-22 Valor · Mascotte, FLThe pilot’s incorrect positioning of both wing fuel valves, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA22LA172Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Melbourne, FLA loss of engine power due to oil starvation as a result of the failure of the No. 3 crankshaft journal bearing.NTSB CEN22LA177Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · McAllen, TXThe pilot’s failure to extend the landing gear due to distraction.NTSB CEN22LA166Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Odessa, TXThe airplane’s encounter with severe clear air turbulence that was not forecasted, which resulted in a serious injury to an unrestrained passenger.NTSB CEN22LA162Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Slidell, LAThe flight instructor’s failure to adequately correct for a loss of directional control during a simulated single engine approach.NTSB CEN22LA159Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RXS-8 · Yutan, NEThe pilot’s improper brace during landing which resulted in a serious injury during the landing sequence.NTSB ANC22LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Anchorage, AKThe flight instructor’s failure to adequately monitor the student pilot which resulted in an impact with terrain and a nose-over.NTSB ERA22LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sparta, TNMaintenance personnel’s failure to properly affix left main landing gear components, which led to the failure of the left main landing gear during the accident flight.NTSB WPR22LA136Accident · No injuriesClass 3 · LimitedFinal reportDowner Bellanca 14-19-2 · Prosser, WAAn inadequately welded elevator attachment lug, which caused the elevator to partially detach from its bellcrank, resulting in flutter and structural damage.NTSB WPR22LA133Accident · Serious injuriesClass 3 · LimitedFinal reportAdams Dennis Allen Varieze · Mojave, CAThe failure of the carburetor intake Sceet tubing, which resulted in a total loss of engine power.