Final NTSB investigations, 2023
97 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 22 |
| 2010 | 32 |
| 2011 | 24 |
| 2012 | 31 |
| 2013 | 17 |
| 2014 | 25 |
| 2015 | 22 |
| 2016 | 22 |
| 2017 | 14 |
| 2018 | 20 |
| 2019 | 37 |
| 2020 | 37 |
| 2021 | 46 |
| 2022 | 75 |
| 2023 | 97 |
| 2024 | 51 |
| 2025 | 10 |
Where
Latest cases
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\") = 2023
AND c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2023 AND c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA24FA072Accident · 1 fatalClass 3 · FieldFinal reportHawker Beechcraft G36 · Buford, GAA loss of engine power for reasons that could not be determined due to significant thermal damage from postimpact fire.NTSB ERA24FA069Accident · 2 fatalClass 3 · FieldFinal reportAmerican Eurocopter AS350B2 · Hammonton, NJThe helicopter’s gradual descent and impact with terrain for reasons that could not be determined.NTSB ERA24LA070Accident · No injuriesClass 3 · LimitedFinal reportBeech A24 · Miami, FLA partial loss of engine power during initial climb for undetermined reasons, resulting in a forced landing.NTSB ANC24FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Anchor Point, AKAn impact to the left wing, at an undetermined time, for reasons that could not be determined, which partially separated the left wing and rendered the airplane uncontrollable.NTSB WPR24LA046Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210N · Big Bear, CAA loss of engine power during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion.NTSB ERA24LA056Accident · No injuriesClass 3 · LimitedFinal reportRaytheon 400A · Atlanta, GAThe collapse of the airplane’s left main landing gear during the landing roll for undetermined reasons.NTSB WPR24LA042Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182G · Casa Grande, AZThe loss of engine power during landing for undetermined reasons.NTSB CEN24LA039Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Ozark, MOA reported total loss of engine power for undetermined reasons.NTSB ERA24LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Lake City, FLA landing gear collapse following an aborted takeoff due to degraded climb performance for reasons that could not be determined.NTSB ERA24LA033Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Orlando, FLA partial loss of engine power during initial climb after takeoff for undetermined reasons.NTSB WPR24LA029Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar International RX 8 · Page, AZA hard landing after both burner pilot lights extinguished during the landing approach for undetermined reasons. Contributing to the accident was the pilot's inability to relight the burner pilot lights.NTSB WPR24LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV-12 · Novato, CAA partial loss of engine power during initial climb for undetermined reasons.NTSB ERA24LA011Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P2010 · Ocala, FLA total loss of engine power for reasons that could not be determined. Contributing to the accident was the flight instructor’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during the forced landing, which…NTSB WPR24FA010Accident · 1 fatalClass 3 · FieldFinal reportRobert L Thurmond RV8 · Centerville, UTThe pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the departure airport, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the failure of the No. 2…NTSB CEN24LA003Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Arlington, TXA reported loss of engine power during the landing approach due to undetermined reasons, which resulted in a forced landing and collision with a fence.NTSB ERA23LA383Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Towanda, PAA total loss of engine power during initial climb for undetermined reasons.NTSB CEN23LA419Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · El Dorado, ARA loss of engine power for undetermined reasons, which resulted in a forced landing and impact with terrain.NTSB ENG23LA045IncidentClass 3 · LimitedFinal reportBell 407 · Linden, NJThe fracture of the upper-left tail boom attachment bolt due to abnormal loading of the bolt caused by a gap and misalignment between the upper-left longeron and the tail boom. Contributing to this incident was the lack of a check to verify the absence of…NTSB ANC23LA080Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Homer, AKA total loss of engine power for undetermined reasons.NTSB ERA23LA373Accident · No injuriesClass 3 · LimitedFinal reportLiore et Oliver Nieuport 28 · Hudson, MAA total loss of engine power for undetermined reasons.NTSB WPR23LA343Accident · Minor injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Monticello, UTA partial loss of engine power for reasons that could not be determined.NTSB WPR23LA341Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · El Cajon, CAA total loss of engine power for undetermined reasons.NTSB ERA23LA365Accident · Minor injuriesClass 3 · LimitedFinal reportSheehan Kevin A Vans RV-8 · Umatilla, FLA total loss of engine power for reasons that could not be determined.NTSB ERA23LA363Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Frankfort, KYA total loss of engine power for reasons that could not be determined.NTSB ERA23LA362Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Cincinnati, OHA loss of engine power for reasons that could not be determined.NTSB ERA23FA357Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Kingston, NJA loss of control, which resulted in the main rotor blade severing the tail boom, for reasons that could not be determined.NTSB CEN23FA391Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Wellington, COThe pilot’s loss of glider control during approach for reasons that could not be determined, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB CEN23LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210B · Wichita, KSLoss of engine power for reasons that could not be determined.NTSB ERA23LA351Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ-6A · Merrickville, NYA total loss of engine power while enroute for reasons that could not be determined.NTSB ANC23LA070Accident · Minor injuriesClass 3 · LimitedFinal reportOliver Robert K Oliver Series 6 · Big Delta, AKA partial loss of engine power for undetermined reasons.NTSB ERA23LA349Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Leonardtown, MDA loss of engine power during an approach to landing for undetermined reasons.NTSB ERA23FA346Accident · 2 fatalClass 3 · FieldFinal reportBeech C-99 · Litchfield, MEA horizontal stabilizer pitch trim anomaly that was not identified in the available evidence.NTSB CEN23LA403Accident · No injuriesClass 3 · LimitedFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Wheeling, ILA loss of braking effectiveness during landing for reasons that could not be determined, which resulted in a runway excursion.NTSB ERA23LA344Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Fostoria, OHA loss of engine power for unknown reasons.NTSB CEN23LA372Accident · No injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Hanover, ILThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during an attempted forced landing at low altitude. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB ERA23LA354Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Fishers Island, NYThe loss of engine power for reasons that could not be determined. Contributing was the pilot’s misjudgment of airspeed and altitude during the forced landing.NTSB CEN23LA376Accident · 1 fatalClass 4 · LimitedFinal reportSixchuter Spirit XL · Hovland, MNThe collision with the lake by a noncertificated pilot for reasons that could not be determined.NTSB ERA23LA359Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 500 S · Key West, FLA total loss of engine power for reasons that could not be determined.NTSB CEN23FA361Accident · Serious injuriesClass 3 · FieldFinal reportMikoyan Gurevich MIG-23UB · Belleville, MIA reported partial loss of engine power while maneuvering for reasons that could not be determined.NTSB ANC23FA061Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Skwentna, AKAn impact with terrain for reasons that could not be determined because the airplane was not recovered due to the inaccessible nature of the accident site.NTSB CEN23LA351Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft F21 · Holliday, TXA loss of engine power for reasons that could not be determined, which resulted in impact with terrain.NTSB WPR23LA304Accident · Minor injuriesClass 3 · LimitedFinal reportVan Grouw R / Cantrell L White Lightning · Las Vegas, NMA reported partial loss of engine power during cruise flight for undetermined reasons.NTSB CEN23FA340Accident · 1 fatalClass 3 · FieldFinal reportRichards Heavylift Helo UH-1H · Oakdale, ILAn in-flight loss of control for undetermined reasons.NTSB CEN23LA337Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CCX-2000 · Winsted, MNA total loss of engine power on approach for undetermined reasons.NTSB WPR23FA286Accident · 1 fatalClass 3 · FieldFinal reportRisen 915 iS · Glendive, MTThe pilot’s failure to maintain airspeed, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/spin.NTSB ERA23LA309Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206-L4 · Caldwell, OHThe helicopter’s uncontrolled vertical descent and impact with terrain for reasons that could not be determined.NTSB CEN23LA318Accident · Minor injuriesClass 3 · LimitedFinal reportBeech H35 · Georgetown, TXA loss of engine power for reasons that could not be determined.NTSB CEN23LA306Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Pocahontas, ILA reported loss of engine power for undetermined reasons.NTSB ANC23LA054Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Twin Hills, AKThe pilot’s loss of control during initial climb for reasons that could not be determined.NTSB CEN23LA297Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Boelus, NELoss of engine power for reasons that could not be determined.