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 WPR22LA082Accident · No injuriesClass 4 · LimitedFinal reportWight Albert A Kitfox Speedster · Shelton, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA22WA078Accident · No injuriesClass 5 · ForeignCessna 172 · Aligarh, IndiaNTSB CEN22LA107Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Angola, INThe pilot’s failure to ensure adequate terrain clearance during an approach. Contributing to the accident was the flight instructor’s delayed remedial action when the airplane descended too low after transitioning to a visual descent to the runway.NTSB GAA22WA086AccidentClass 5 · ForeignAir Tractor AT602 · Luís Eduardo Magalhães,, BrazilNTSB ERA22LA437Accident · No injuriesClass 4 · LimitedFinal reportWhiting Cleon Glasair SH-2 · Palmetto, FLThe pilot’s loss of directional control during takeoff roll.NTSB GAA22WA097Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Florianopolis, BrazilNTSB GAA22WA088Incident · No injuriesClass 5 · ForeignBeech C90 · Pampulha-SBBH, BrazilNTSB GAA22WA087Accident · No injuriesClass 5 · ForeignBeech 58 · Curitiba, BrazilNTSB WPR22LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Scottsdale, AZA loss of engine power due to oil exhaustion.NTSB ERA22LA110Accident · Serious injuriesClass 4 · LimitedFinal reportMiller Roger Thatcher CX4 · Angier, NCThe pilot’s encounter with a flock of birds on final approach, which resulted in a loss of control, an aerodynamic stall and spin, and impact with trees and terrain.NTSB CEN22LA104Accident · No injuriesClass 4 · LimitedFinal reportBeech V35B · McKinney, TXThe pilot’s failure to maintain control during the landing with gusty wind.NTSB CEN22LA103Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 120 · Sturtevant, WIThe pilot’s loss of directional control during the takeoff for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.NTSB GAA22WA320Accident · No injuriesClass 5 · ForeignBeech C90 · Bucaramanga, ColombiaNTSB DCA22WA074Accident · Serious injuriesClass 5 · ForeignAirbus A320 · Okayama City, JapanNTSB CEN22LA101Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6C · San Antonio, TXThe pilot’s loss of directional control during landing.NTSB ANC22LA013Accident · Minor injuriesClass 4 · LimitedFinal reportLeach Michael Rans S7S · Winnemucca, NVThe pilot’s failure to ensure the airplane’s wings were free of contaminates before departure.NTSB GAA22WA075Accident · 1 fatalClass 5 · ForeignPiper PA-25-260 · Uchoa, BrazilNTSB DCA22WA089IncidentClass 5 · ForeignAirbus A320 · Sukkur, PakistanNTSB DCA22WA071Incident · No injuriesClass 5 · ForeignBoeing 737 · Barcelona, VenezuelaNTSB CEN22LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Lamesa, TXThe pilot’s failure to maintain clearance from terrain during a descent that resulted in an impact with terrain.NTSB ANC22LA014Accident · No injuriesClass 3 · LimitedFinal reportBell 205A-1 · El Cajon, CAA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB ANC22LA012Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Hana, HIThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB WPR22LA080Accident · Serious injuriesClass 3 · LimitedFinal reportWalter Tachiki Tachiki 750 Cruzer · Spanish Fork, UTA partial loss of engine power due to an obstructed catalytic converter, which most likely resulted from the pilot’s failure to properly repair or replace it after it was likely damaged during a previous incident. Contributing to the accident was the pilot’s…NTSB GAA22WA085Accident · No injuriesClass 5 · ForeignMD Helicopter 369 · International Waters, PanamaNTSB CEN22LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Carrizo Springs, TXThe pilot’s failure to maintain directional control of the airplane during landing with a gusting crosswind that resulted in a runway excursion.NTSB CEN22FA100Accident · 2 fatalClass 3 · FieldFinal reportBell 407 · Houma, LAThe pilot’s sudden loss of consciousness for undetermined reasons during cruise flight, which resulted in a loss of control and impact with terrain.NTSB WPR22LA088Accident · No injuriesClass 3 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Phoenix, AZThe failure of the right brake due to the separation of the brake pad from the brake assembly. Also causal was the improper maintenance of the airplane, which resulted in the use of a brake pad that was inappropriate for the airplane make and model.NTSB WPR22LA079Accident · No injuriesClass 4 · LimitedFinal report2021fx3 CCX-2000 · Redmond, ORThe pilot's failure to maintain directional control during the landing roll.NTSB GAA22WA314Accident · No injuriesClass 4 · ForeignAir Tractor AT602 · Santo Tome, Corrientes, ArgentinaNTSB GAA22WA080Accident · No injuriesClass 5 · ForeignBell 412 · Valencia, SpainNTSB ERA22LA109Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lexington, SCA loss of engine power due to a shift of the No. 3 main journal bearing, which resulted in blocked oil ports that restricted oil to the engine’s internal components and a subsequent catastrophic engine failure.NTSB ERA22LA107Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Winter Haven, FLThe pilot receiving instruction’s failure to maintain airspeed during a turn, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor’s failure to…NTSB ERA22LA106Accident · No injuriesClass 4 · LimitedFinal reportCharles C Menger JR Safari 400 · Gallatin, TNA reported stuck throttle for reasons that could not be determined during postaccident examinations and subsequent loss of control during hover.NTSB GAA22WA094Incident · No injuriesClass 4 · ForeignRobinson R22 · Mitchell, AustraliaNTSB ERA22LA129Accident · No injuriesClass 4 · LimitedFinal reportLindstrand Balloons 60X · Louisville, KYThe pilot applicant’s delayed reaction to the balloon's increased rate of descent, which resulted in impact with a light pole.NTSB ERA22LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Edisto Island, SCA loss of engine power due to the fatigue failure of the crankshaft counterweight retaining ring and the No. 6 connecting rod.NTSB ERA22FA105Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter Deutschland EC135 P2+ · Drexel Hill, PAAn inflight attitude upset for undetermined reasons that resulted in a rotor system overspeed, a reduction of power from both engines, and a subsequent hard landing.NTSB CEN22LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Wahoo, NEThe pilot’s failure to maintain directional control during the landing.NTSB WPR22LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Creswell, ORThe pilot’s excessive left brake pedal application during landing roll, which resulted a loss of directional control, runway excursion, and nose over.NTSB GAA22WA116Accident · No injuriesClass 5 · ForeignCruiser PS-28 · Casarrubios, SpainNTSB WPR22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Los Angeles, CAThe pilot’s inadequate preflight inspection during which he failed to remove all water contamination in the fuel system, which resulted in a total loss of engine power on takeoff. Contributing to the accident was the condition of the fuel caps, which allowed…NTSB CEN22FA096Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Defiance, MOThe pilot’s loss of airplane control while flying in night instrument conditions due to spatial disorientation and the flight crew’s inability to recover from an unusual airplane attitude.NTSB ERA22LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Knoxville, TNThe pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.NTSB CEN22LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Youngstown, OHA loss of engine power for reasons that could not be determined based on available information, which resulted in a forced landing.NTSB GAA22WA205AccidentClass 5 · ForeignCessna 560 · South Ruislip, United KingdomNTSB GAA22WA069Accident · 2 fatalClass 5 · ForeignRobinson R44 · 63 Puy-de-Dome, FranceNTSB GAA22WA068Accident · Minor injuriesClass 4 · ForeignCessna 402B · Berry Islands, BahamasNTSB DCA22WA223OccurrenceClass 5 · ForeignBoeing 737 · Durgapur, IndiaNTSB DCA22WA068IncidentClass 5 · ForeignBoeing 737 · Santiago, VenezuelaNTSB CEN22LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Washington, INThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions which resulted in a runway excursion.