NTSB investigations, 2024
122 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 31 |
| 2010 | 52 |
| 2011 | 44 |
| 2012 | 47 |
| 2013 | 43 |
| 2014 | 65 |
| 2015 | 82 |
| 2016 | 100 |
| 2017 | 83 |
| 2018 | 98 |
| 2019 | 83 |
| 2020 | 87 |
| 2021 | 95 |
| 2022 | 124 |
| 2023 | 152 |
| 2024 | 122 |
| 2025 | 120 |
| 2026 | 264 |
Where
Open the mapLatest 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\") = 2024
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") = 2024 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 DCA25WA069Accident · 35 fatalClass 5 · ForeignEmbraer ERJ190 · Aktau, KazakhstanNTSB ANC25FA010Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 208B · Honolulu, HIOn December 17, 2024, about 1515 Hawaii-Aleutian Standard time, a turbine-powered Cessna 208B airplane, N689KA, was destroyed when it was involved in an accident near Honolulu, Hawaii. The two pilots onboard were fatally injured. The airplane was operated as…NTSB CEN25LA058Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Smithville, TXA loss of engine power for undetermined reasons.NTSB GAA25WA038Accident · Serious injuriesClass 5 · ForeignThrush S2R · Teyman, IsraelNTSB CEN25FA052Accident · 2 fatalClass 3 · FieldPreliminary reportCozy MK III · Mineola, TXOn November 27, 2024, about 18:30 central standard time, a Cozy Mark III, N51810 was destroyed when it was involved in an accident near Mineola, Texas. The pilot and passenger were fatally injured. The flight was operated under the provisions of Title 14 Code…NTSB ERA25FA058Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Windham, NYOn November 24, 2024, at about 1809 eastern standard time, a Mooney M20J, N58156, was substantially damaged when it was involved in an accident near Windham, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA25WA033Accident · 2 fatalClass 5 · ForeignPiper PA-28-140 · Cimanes del Tejar, SpainNTSB GAA25WA031Accident · 1 fatalClass 5 · ForeignAerospatiale AS332L · Broken Hill, AustraliaNTSB ENG25WA039AccidentClass 5 · ForeignDiamond DA42 · Ben Slimane, MoroccoNTSB ERA25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportJames A Gray Just Aircraft Highlander · Fountain Inn, SCA total loss of engine power for undetermined reasons.NTSB WPR25LA039Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32-300 · Pomona, CAA total loss of engine power during final approach for reasons that could not be determined.NTSB GAA25WA030Accident · 3 fatalClass 5 · ForeignCessna 172 · Murska Sobota, SloveniaNTSB GAA25WA029Accident · 1 fatalClass 5 · ForeignAir Tractor AT602 · SãO Paulo, BrazilNTSB GAA25WA022Accident · Serious injuriesClass 5 · ForeignBell 205 · Región del Maule, ChileNTSB GAA25WA023Accident · 2 fatalClass 4 · ForeignCessna 172 · Fujairah, United Arab EmiratesNTSB ERA25LA044Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C-1 · Boalsburg, PAA loss of engine power for reasons that could not be determined.NTSB WPR25FA031Accident · 5 fatalClass 3 · FieldPreliminary reportHonda HA420 · Mesa, AZOn November 5, 2024, at 1639 mountain daylight time, a Honda HA-420, N57HP, was destroyed when it was involved in an accident near Mesa, AZ. The pilot and three passengers were fatally injured, one passenger was seriously injured, and the single occupant of…NTSB WPR25LA027Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · St. George, UTA partial loss of power for reasons that could not be determined due to postimpact fire damage.NTSB GAA25WA016Accident · Serious injuriesClass 4 · ForeignCessna 340A · Saint-Denis-de-l'Hôtel, FranceNTSB GAA25WA015Accident · 8 fatalClass 5 · ForeignSikorsky S76 · Port Harcourt, NigeriaNTSB DCA25WA028Incident · No injuriesClass 5 · ForeignBoeing 767-332 · Ndiass, SenegalNTSB CEN25LA020Accident · No injuriesClass 4 · LimitedFinal reportStarship Enterprise · Addison, TXForeign object debris damage to the ventral stabilizer.NTSB WPR25FA007Accident · 5 fatalClass 3 · FieldPreliminary reportBeech 95-B55 · Avalon, CAOn October 8, 2024, at 2005 Pacific daylight time, a Beech 95-B55, N73WA, was destroyed when it was involved in an accident near Avalon, California. The pilot, two pilot rated passengers, and two student pilot passengers were fatally injured. The airplane was…NTSB GAA25WA021Accident · No injuriesClass 5 · ForeignEmbraer 500 · Centerline, FranceNTSB CEN25FA005Accident · 1 fatalClass 3 · FieldPreliminary reportChampion 7EC · Fort Worth, TXOn October 7, 2024, about 1240 central daylight time, a Champion 7EC airplane, N4337C, sustained substantial damage when it was involved in an accident near Fort Worth, Texas. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of…NTSB DCA25LA001Incident · Minor injuriesClass 3 · LimitedPreliminary reportAirbus A321-211 · Las Vegas, NVOn October 5, 2024, at 1510 Pacific daylight time, Frontier Airlines flight 1326, an Airbus A321-211, N701FR, was involved in an incident due to a brake fire during landing on runway 26L at Harry Reid International Airport (LAS), Las Vegas, Nevada. The…NTSB ANC24FA091Accident · 2 fatalClass 3 · FieldPreliminary reportChampion 7GCBC · Ninilchik, AKOn September 13, 2024, about 0803 Alaska daylight time (AKDT), a Champion (Citabria) 7GCBC, N8CK, was substantially damaged when it was involved in an accident near Ninilchik, Alaska. The pilot and passenger were fatally injured. The airplane was operated as…NTSB CEN24FA353Accident · 1 fatalClass 3 · FieldPreliminary reportHawker Beechcraft G36 · Lafayette, LAOn September 12, 2024, about 1137 central daylight time, a Hawker Beechcraft G36 airplane, N643RS, was destroyed when it was involved in an accident near Lafayette, Louisiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN24LA344Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Rifle, COA total loss of engine power for undetermined reasons.NTSB GAA24WA280Accident · 1 fatalClass 5 · ForeignGreat Lakes 2T-1A-2 · Gütersloh, GermanyNTSB ERA24FA365Accident · 2 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5 · Rockmart, GAA total loss of engine power for undetermined reasons. Also causal was the flight instructor’s failure to maintain adequate airspeed during the forced landing attempt, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic…NTSB CEN24LA336AccidentClass 4 · LimitedFinal reportCessna 182D · Coopersville, MIThe loss of airplane control while landing.NTSB ERA24LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lynchburg, VAA total loss of engine power for undetermined reasons.NTSB WPR24FA287Accident · Serious injuriesClass 3 · FieldFinal reportPitts S1 · Santa Paula, CAThe total loss of engine power at low altitude for reasons that could not be determined.NTSB GAA24WA299Accident · Minor injuriesClass 3 · ForeignLeonardo AQ139 · Paul Village, IndiaNTSB GAA24WA300Accident · 9 fatalClass 5 · ForeignCessna 208 · What Khao Din, ThailandNTSB GAA24WA282Accident · 2 fatalClass 5 · ForeignPartenavia P66 · LIAA (Identifier), ItalyNTSB GAA24WA266Accident · 2 fatalClass 3 · ForeignCessna 152 · Jamshedpur, IndiaNTSB GAA24WA264AccidentClass 5 · ForeignAirbus A350 · Lac D’Elvert, CanadaNTSB GAA24WA261Accident · No injuriesClass 5 · ForeignPiper PA-34-200T · Kingston, JamaicaNTSB GAA24WA273AccidentClass 5 · ForeignBell 206 · Escuintla, GuatemalaNTSB GAA24WA260Accident · 1 fatalClass 5 · ForeignCessna 152 · Santa Fe, ArgentinaNTSB GAA24WA252Accident · 1 fatalClass 5 · ForeignCessna 337 · Deer Lake, CanadaNTSB CEN24FA312Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Elkhart, ILAn off-airport landing in a soybean field for reasons that could not be determined. Contributing to the severity of the pilot’s injuries and airplane damage was a fire that occurred at an unknown time.NTSB GAA24WA240AccidentClass 5 · ForeignBRM Aero Sro Bristell S-LSA · Aboco, BahamasNTSB CEN24FA298Accident · 1 fatalClass 3 · FieldFinal reportDeGraw DeBird · Napoleon, MISeparation of the gyroplane’s tail due to main rotor blade contact for reasons that could not be determined.NTSB WPR24LA269Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Lodi, CAA reported loss of engine power for reasons that could not be determined.NTSB ERA24LA335Accident · Serious injuriesClass 3 · LimitedFinal reportHendrickson Glasair 3 · Oxford, MEA loss of engine power for reasons that could not be determined.NTSB CEN24LA303Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Bryant, IAA loss of engine power during takeoff for reasons that could not be determined, resulting in impact with terrain.NTSB ANC24LA073Accident · No injuriesClass 3 · LimitedFinal reportDe Havilland DHC2 · Anchorage, AKA partial loss of power during takeoff climb for undetermined reasons.