NTSB investigations, 2022
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 WHERE year(c.\"eventDate\") = 2022 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 WHERE year(c."eventDate") = 2022 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 DCA23WA029Accident · No injuriesClass 5 · ForeignAirbus A330 · Mactan-Cebu, PhilippinesNTSB CEN23LA018Accident · No injuriesClass 3 · LimitedFinal reportSea Ray LSX · Lago Vista, TXThe pilot’s inadequate fuel planning and improper in-flight decision making which resulted in a low fuel status and a loss of engine power due to fuel starvation.NTSB CEN23LA017Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Loveland, COThe pilot’s loss of control after encountering windshear while landing in a strong, gusting crosswind. Contributing was pilot’s decision to continue the landing with a 90-degree crosswind at 30 knots.NTSB GAA23WA013AccidentClass 5 · ForeignPiper PA30 · Quebec, CanadaNTSB ERA23LA035Accident · No injuriesClass 3 · LimitedFinal reportBeech V35A · Shellman Bluff, GAThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna A185E · York, PAOil starvation of the number 1 connecting rod bearings, which resulted in a total loss of engine power.NTSB DCA23WA041IncidentClass 5 · ForeignBoeing 737 · Agadir, MoroccoNTSB ERA23LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Toughkenamon, PAThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in substantial damage to the airplane.NTSB ERA23LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Factoryville, PAThe pilot's failure to maintain directional control while practicing a soft-field takeoff maneuver, which resulted in a runway excursion and impact with a hangar.NTSB ERA23FA033Accident · 2 fatalClass 3 · FieldFinal reportBeech A24 · Keene, NHImproper maintenance of the fuel injector nozzles and the pilots’ failure to abort the takeoff during the takeoff roll. Contributing to the accident was the mechanic’s decision to return the airplane to service with the engine unable to attain its full rated…NTSB DCA23WA025IncidentClass 5 · ForeignBoeing 737 · Dhaka, BangladeshNTSB CEN23FA016Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Chandler, TXThe loss of control inflight for reasons that could not be determined.NTSB WPR23LA022Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35B · Nogales, AZThe pilot’s failure to establish a positive rate of climb before retracting the landing gear when he executed an aborted landing, which resulted in a propeller strike, diminished climb performance, and the inadvertent contact with terrain.NTSB WPR23LA021Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Georgetown, CAThe pilot’s failure to maintain control during an attempted go-around, which resulted in a runway excursion and a separation of the right main landing gear.NTSB DCA23WA031Incident · No injuriesClass 5 · ForeignEmbraer EMB145 · Paris, FranceNTSB GAA23WA018Accident · Serious injuriesClass 5 · ForeignBell 407 · São Paulo, BrazilNTSB GAA23WA012Accident · 1 fatalClass 5 · ForeignThrush S2R-T660 · Sierra Segundera, SpainNTSB DCA23WA046IncidentClass 5 · ForeignBoeing 737 · Sydney, AustraliaNTSB WPR23LA024Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Evanston, WYThe pilot’s failure to maintain directional control during takeoff, resulting in a runway excursion and ground loopNTSB WPR23LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Mesa, AZThe failure of maintenance personnel to properly secure the fuel supply line to the fuel flow divider, which resulted in a fuel leak, fuel exhaustion, and a total loss of engine power.NTSB GAA23WA017Accident · 2 fatalClass 5 · ForeignCessna T206G · Guayaquil, EcuadorNTSB GAA23WA014Incident · No injuriesClass 3 · ForeignCessna 172 · Yao, JapanNTSB GAA23WA009Accident · 7 fatalClass 5 · ForeignBell 407 · Rudraprayag, IndiaNTSB ERA23FA025Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Brentwood, TNA total loss of engine power due to the catastrophic failure of the crankshaft resulting from the improper installation of the crankshaft for this application.NTSB ERA23FA024Accident · 2 fatalClass 3 · FieldFinal reportBeech E-90 · Marietta, OHStructural icing on the tailplane that resulted in a tailplane stall and subsequent loss of control.NTSB GAA23WA008Accident · Serious injuriesClass 5 · ForeignMooney M20J · Luskintyre, AustraliaNTSB ERA23LA022Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172S · Statesboro, GAThe pilot’s failure to include deplaning procedures as part of a passenger safety briefing and failure to have the passengers remain onboard until the engine was shut down, which resulted in a passenger subsequently being struck by the rotating propeller.NTSB ERA23FA023Accident · 2 fatalClass 3 · FieldFinal reportPeryera Adventura II · Miramar, FLThe pilot’s failure to remove the ECU select switch per the manufacturer’s service bulletin, which resulted in a loss of engine power.NTSB GAA23WA007Accident · 1 fatalClass 3 · ForeignCirrus SF50 · Santa Marta, ColombiaNTSB ERA23LA026Accident · Serious injuriesClass 4 · LimitedFinal reportKolb Firestar II · West Alexandria, OHThe pilot’s failure to maintain airplane control after takeoff, resulting in an aerodynamic stall and collision with terrain.NTSB ANC23LA002Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-32-260 · Cordova, AKThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR23LA023Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Marble Canyon, AZThe pilot’s loss of directional control during a takeoff from a rough, narrow runway, resulting in an aborted takeoff and subsequent runway excursion.NTSB WPR23LA019Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne SeaRey · Lake Isabel, WAThe pilot’s loss of airplane control after an encounter with windshear during takeoff which, resulted in a hard water landing.NTSB WPR23LA018Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-60 · Herlong, NVThe pilot's failure to maintain adequate separation during a formation flight, which resulted in an encounter with wake turbulence, an aerodynamic stall, and collision with terrain.NTSB WPR23LA015Accident · No injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Prescott, AZThe pilot’s loss of directional control during landing with a wind gust, which resulted in a runway excursion and nose over.NTSB WPR23LA014Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Petaluma, CAThe pilot’s failure to maintain directional control during landing in gusting wind.NTSB WPR23LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Tucson, AZThe pilot’s loss of control during landing for reasons that could not be determined based on the available evidence.NTSB GAA23WA016Incident · No injuriesClass 5 · ForeignBell 206 · Kitakyushu, JapanNTSB ERA23LA039Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Kingstree, SCThe airplane’s impact with two deer during the landing roll.NTSB ERA23LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Elizabethtown, KYThe pilot's decision to continue the taxi without visual reference to the surface, due to his vision being impaired by darkness and glare, which resulted in the airplane’s departure from the paved surface and impact with a ditch. Contributing was the flight…NTSB CEN23LA014Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 62 · Dallas, TXA total loss of airplane electrical power for undetermined reasons, which resulted in a complete loss of engine power to both engines. Contributing was the worn main battery and the incorrectly wired ECU backup batteries.NTSB WPR23LA016Accident · No injuriesClass 3 · LimitedFinal reportQuickie Q2 · Laramie, WYThe partial loss of engine power due to the seizure of the No. 1 cylinder exhaust valve in the valve guide.NTSB GAA23WA011Incident · No injuriesClass 5 · ForeignCessna 402 · Bahia Solano, ColombiaNTSB ERA23LA032Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Lawrenceburg, TNThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA23LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Montgomery, ALThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA23LA028Accident · No injuriesClass 4 · LimitedFinal reportMcglaughlin Richard Sportsman GS2 · Pell City, ALThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.NTSB ERA23LA021Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Daytona Beach, FLThe pilot’s misjudged landing point which resulted in a loss of control and collision with terrain.NTSB ERA23LA019Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe student pilot’s loss of directional control on landing.NTSB DCA23WA019IncidentClass 5 · ForeignBoeing 787-9 · Keflavík, IcelandNTSB GAA23WA015Accident · 1 fatalClass 3 · ForeignCessna 172 · Ulsan, South Korea