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 WPR22LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Corona, CAThe pilot receiving instruction failure to extend the landing gear before landing due to distraction and the flight instructor’s inadequate supervision.NTSB GAA22WA074AccidentClass 5 · ForeignCessna 177 · Gauteng Province, South AfricaNTSB ERA22LA082Accident · Minor injuriesClass 3 · LimitedFinal reportBeech S35 · Tallahassee, FLA total loss of engine power due to a lack of oil lubrication.NTSB WPR22FA055Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Medford, ORThe pilot’s failure to maintain aircraft control during the initial climb into clouds due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain.NTSB WPR22LA056Accident · No injuriesClass 4 · LimitedFinal reportMonte Clark Vans RV8 · Hamilton, MTThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR22FA054Accident · 4 fatalClass 3 · FieldFinal reportBeech V35 · Visalia, CAThe pilot’s loss of control due to spatial disorientation shortly after takeoff. Contributing to the accident was the pilot’s decision to depart into night instrument meteorological conditions.NTSB GAA22WA040AccidentClass 5 · ForeignAir Tractor AT-400 · Bulyeroi, AustraliaNTSB GAA22WA038Accident · 2 fatalClass 5 · ForeignMurphy Rebel · Wasbush, CanadaNTSB ERA22LA081Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Bennettsville, SCThe pilot’s inadequate preflight planning, resulting in a takeoff attempt from a grass parking area instead of the runway and subsequent impact with a pole.NTSB CEN22LA071Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Wichita Falls, TXThe pilot’s improper fuel management that resulted in a total loss of engine power due to fuel starvation.NTSB CEN22FA058Accident · 1 fatalClass 3 · FieldFinal reportCessna 182L · Bonnerdale, ARThe noninstrument rated pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent impact with terrain.NTSB WPR22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Hachita, NMThe pilot’s failure to adequately monitor the environment during a low level operation, which resulted in collision with vegetation.NTSB GAA22WA041AccidentClass 5 · ForeignPiper PA34 · Gauteng, South AfricaNTSB GAA22WA037Accident · 3 fatalClass 5 · ForeignCessna A185 · Laguna Negra, ParaguayNTSB ERA22LA084Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, VACollision with a bird in flight, which resulted in damage to the right-wing leading-edge spar.NTSB DCA22WA063IncidentClass 5 · ForeignBoeing 737 · Singapore, SingaporeNTSB CEN22LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Tahlequah, OKA loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.NTSB WPR22FA053Accident · 1 fatalClass 3 · FieldFinal reportRussell W Dyer Vortex · Lakeport, CAThe pilot’s loss of control for reasons that could not be determined and the delayed remedial action to recover from the power pushover event.NTSB CEN22LA063Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · St. Louis, MOThe pilot’s failure to apply power during the recovery procedure for the practice autorotation, which resulted in a hard landing.NTSB CEN22LA059Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Cleveland, TXA total loss of engine power due to fuel starvation, the reason for which could not be determined.NTSB ANC22LA009Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 208 · Port Alsworth, AKThe pilot's failure to maintain a proper approach path which resulted in landing short of the runway and impact with terrain.NTSB WPR22LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 510 · Havasu, AZThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.NTSB DCA22WA039IncidentClass 5 · ForeignBoeing 737 · Kuusamo, FinlandNTSB CEN22LA061Accident · Serious injuriesClass 4 · LimitedFinal reportExperimental Nieuport-12 · Midland, TXThe pilot’s loss of directional control during a high-speed taxi operation and subsequent collision with terrain during the inadvertent flight.NTSB CEN22LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Cassville, MOThe pilot’s failure to reinstall the nose landing gear linkage prior to the flight which resulted in a loss of directional control during landing.NTSB WPR22LA051Accident · No injuriesClass 4 · LimitedFinal reportTravel Air 4-D · Riverside, CAThe pilot's failure to abort a high-speed taxi in time before the airplane exited the end of the airstrip which resulted in the pilot’s over application of the brakes and subsequent nose over.NTSB ERA22LA094Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C · Kissimmee, FLThe pilot’s inadvertent application of brakes during touchdown, which resulted in a noseover.NTSB ERA22LA080Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Labelle, FLThe pilot’s improper fuel system modification, which resulted in a loss of engine power due to fuel exhaustion.NTSB DCA22WA057IncidentClass 5 · ForeignCanadair CRJ-900 · San Diego, CANTSB ANC22LA010Accident · No injuriesClass 4 · LimitedFinal reportFound Acft Canada FBA-2C1 · Kenai, AKThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB ERA22LA079Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA46 · Cornelia, GAThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB DCA22LA038Accident · No injuriesClass 4 · LimitedFinal reportBoeing 747-4B5F · Miami, FLIncorrect lubrication of the foreflap fitting assembly.NTSB WPR22LA075Accident · Serious injuriesClass 4 · LimitedFinal reportSchulze Erwin E JR SHA Glasair SH-2R · Santa Paula, CAThe pilot’s failure to extend the landing gear before landing.NTSB WPR22LA063Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Eugene, ORThe pilot’s improper checklist use, which resulted in an electrical malfunction and subsequent gear up landing.NTSB CEN22LA055Accident · Minor injuriesClass 4 · LimitedFinal reportRay Earl D Flightstar Iisc · Haskell, OKA sudden loss of engine power after takeoff for undetermined reasons based on the information available.NTSB CEN22FA053Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · Perry, OKA loss of lateral control during a hover that resulted in an impact with terrain. Based on the available evidence, the reason for the loss of lateral control could not be determined.NTSB WPR22LA052Accident · No injuriesClass 4 · LimitedFinal reportBagley Curtis Lynn Rans S-6S Coyote II · Fairfield, UTThe pilot's failure to maintain directional control during takeoff with a right crosswind.NTSB GAA22WA048Incident · No injuriesClass 5 · ForeignBAE ATP · Belfast, United KingdomNTSB GAA22WA060Accident · 3 fatalClass 4 · ForeignPiper PA34 · Ubatuba, BrazilNTSB ERA22LA093Accident · No injuriesClass 4 · LimitedFinal reportTecnam P92 · Apopka, FLThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a runway excursion and impact with a hangar.NTSB ANC22LA008Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Palmer, AKThe pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power, off-airport landing, and nose over.NTSB GAA22WA082Accident · 1 fatalClass 5 · ForeignCubcrafters CC11-160 · Monterrey, MexicoNTSB DCA22WA035Incident · No injuriesClass 5 · ForeignBoeing 767-332 · Bogata, ColombiaNTSB WPR22LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Tooele, UTThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB WPR22LA050Accident · Serious injuriesClass 4 · LimitedFinal reportAlon A2 · Frazier Park, CAThe pilot’s failure to maintain adequate airspeed while on approach for landing which, resulted in an aerodynamic stall and collision with terrain.NTSB WPR22LA049Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BL-65 · New Cuyama, CAThe pilot’s decision to intentionally crash the airplane.NTSB GAA22WA059AccidentClass 5 · ForeignCessna A188 · Joao Pinheiro, BrazilNTSB ERA22FA076Accident · 2 fatalClass 3 · FieldFinal reportCessna T210R · Grove City, PAA catastrophic engine failure due to oil starvation after the pilot’s failure to secure the oil filler cap before flight. Contributing to the accident was the pilots’ decision to continue the flight following the oil loss event and precautionary landing.NTSB WPR22FA048Accident · 1 fatalClass 3 · FieldFinal reportZenith Zodiac CH601XL · Temecula, CAThe failure of the airplane’s canopy latch system, which resulted in the canopy opening in flight and a loss of airplane control. Contributing to the accident was the lack of a secondary canopy latch as recommended by the kit manufacturer.NTSB ERA22LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301 · Orlando, FLThe pilot’s inadequate compensation for winds during the landing roll.