NTSB investigations
1,709 cases where the sequence of events included Unknown or undetermined.
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 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 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 ANC25FA035Accident · 2 fatalClass 3 · FieldPreliminary reportCessna T207 · Nanwalek, AKOn April 28, 2025, about 1355 Alaska daylight time, a Cessna T207 airplane, N91025, was substantially damaged when it was involved in an accident near Nanwalek, Alaska. The pilot and one passenger were fatally injured. One passenger was seriously injured. The…NTSB DCA25WA301IncidentClass 5 · ForeignBoeing 737 · Luton, United KingdomNTSB GAA25WA146Incident · No injuriesClass 5 · ForeignHonda HA420 · Chubu, JapanNTSB GAA25WA138Accident · 2 fatalClass 5 · ForeignPiper PA60 · Salzgitter, GermanyNTSB WPR25MA128Accident · 6 fatalClass 3 · MajorPreliminary reportMitsubishi MU-2B-40 · Copake, NYOn April 12, 2025, about 1203 eastern daylight time, a Mitsubishi MU-2B-40, N635TA, was destroyed when it was involved in an accident near Copake, New York. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR25FA126Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20F · Reliance, TNOn April 11, 2025, about 1402 eastern daylight time, a Mooney M20F, N7026V, sustained substantial damage when it was involved in an accident near Reliance, Tennessee. The pilot, pilot-rated passenger and passenger were fatally injured. The airplane was…NTSB CEN25LA149Accident · Serious injuriesClass 3 · LimitedFinal reportPphu Ekolot KR-030 Topaz · Platteville, WIThe pilot’s failure to maintain clearance from terrain for reasons which could not be determined.NTSB GAA25WA132Accident · 2 fatalClass 5 · ForeignChampion 8KCAB · Bergen, NorwayNTSB DCA25WA176Incident · No injuriesClass 5 · ForeignMcdonnell Douglas MD 83 · Havana, CubaNTSB GAA25WA126Accident · 1 fatalClass 4 · ForeignSikorsky S76 · Euiseong, South KoreaNTSB GAA25WA120Accident · Minor injuriesClass 5 · ForeignAlan D Ham Vans RV-7A · Santiago Atitlan, GuatemalaNTSB DCA25WA167Accident · 5 fatalClass 5 · ForeignDe Havilland DHC5 · Jazeera, SomaliaNTSB GAA25WA129Accident · No injuriesClass 5 · ForeignMcdonnell Douglas Helicopter 600 · Dos Ríos, MexicoNTSB GAA25WA115AccidentClass 5 · ForeignJetstreaM 32 · Coxen Hole, HondurasNTSB GAA25WA113Accident · 1 fatalClass 5 · ForeignMooney M20R · Velika Planina, SloveniaNTSB CEN25MA115Accident · 3 fatalClass 2 · MajorPreliminary reportEurocopter Deutschland EC 135 P2+ · Canton, MSOn March 10, 2025, about 1237 central daylight time, an Airbus Helicopters (formerly Eurocopter Deutschland) EC135 P2+ helicopter, N835CS, operated as AirCare 3, was destroyed when it was involved in an accident near Canton, Mississippi. The commercial pilot,…NTSB CEN25LA116Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Chicago, ILOn March 10, 2025, about 18:30 central daylight time, a Robinson Helicopter R44 II, N128AF was substantially damaged when it was involved in an accident near Chicago, Illinois. The pilot and both passengers were not injured. The helicopter was operated under…NTSB GAA25WA105AccidentClass 5 · ForeignSievers KS-206-A (OH58) · Chiquimula, GuatemalaNTSB GAA24WA320IncidentClass 5 · ForeignCessna 525A · Shizuoka, JapanNTSB GAA25WA117Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Balsas, BrazilNTSB ANC25LA019Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKA total loss of engine power for undetermined reasons.NTSB GAA25WA107AccidentClass 5 · ForeignCessna C185-A · Samburu, KenyaNTSB GAA25WA095AccidentClass 5 · ForeignPiper PA38 · Barangay Lalang,, PhilippinesNTSB GAA25WA091Accident · 2 fatalClass 5 · ForeignHughes 269C · Dippenricht, GermanyNTSB GAA25WA084Accident · 1 fatalClass 5 · ForeignBell 206 · Polokwane Civil Aerodrome, South AfricaNTSB GAA25WA078AccidentClass 5 · ForeignRobinson R44 · San Miguel, PhilippinesNTSB GAA25WA079Accident · Serious injuriesClass 5 · ForeignCessna 188 · Santa Cruz, BoliviaNTSB ERA25MA106Accident · 7 fatalClass 2 · MajorPreliminary reportLearjet 55 · Philadelphia, PAOn January 31, 2025, at 1807 eastern standard time, a Learjet 55 airplane, Mexican registration XA-UCI (call sign MTS056) was destroyed when it was involved in an accident in Philadelphia, Pennsylvania. The two pilots, two medical crewmembers, and two…NTSB GAA25WA083Accident · 1 fatalClass 5 · ForeignCessna C185F · Naivasha, KenyaNTSB WPR25LA085Accident · Serious injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Santa Barbara, CAOn January 29, 2025, about 1417 Pacific standard time, a Cirrus Design Corp SR22T, N124LZ, was destroyed when it was involved in an accident near Santa Barbara, California. The two pilots were seriously injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA082Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172K · Columbia, CAA partial loss of engine power for undetermined reasons.NTSB GAA25WA052Accident · 3 fatalClass 5 · ForeignCessna 208 · Rottnest Island, AustraliaNTSB WPR25LA080Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-32-300 · Round Mountain, NVImpact with mountainous terrain for reasons that could not be determined due to a lack of available evidence.NTSB WPR25FA072Accident · 2 fatalClass 3 · FieldPreliminary reportVans RV-10 · Fullerton, CAOn January 2, 2025, about 1409 Pacific standard time, an experimental amateur built Vans Aircraft RV-10, N8757R, was destroyed when it was involved in an accident near Fullerton, California. The pilot and passenger were fatally injured, and there were 19…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.