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 GAA26WA153Accident · Minor injuriesClass 5 · ForeignCessna T210 · Antônio João, BrazilNTSB GAA26WA171Accident · 1 fatalForeign investigationRobinson R44 · New Brunswick, CanadaNTSB GAA26WA140Accident · 1 fatalClass 5 · ForeignThrush S2R · San Juan, EcuadorNTSB GAA26WA139Accident · No injuriesClass 5 · ForeignPiper PA46 · Mayaguana, BahamasNTSB CEN26FA147Accident · 1 fatalClass 3 · FieldPreliminary reportExperimental Homebuilt Airshark · Statesboro, GAOn March 25, 2026, about 1453 eastern daylight time, an experimental homebuilt Airshark airplane, N220AS, was substantially damaged when it was involved in an accident near Statesboro, Georgia. The pilot was fatally injured. The airplane was operated as a…NTSB GAA26WA143Accident · Serious injuriesClass 5 · ForeignSikorsky S61 · Cheonan, South KoreaNTSB WPR26FA130Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Olympic Valley, CAOn March 22, 2026, at 1716 Pacific daylight time, a Beech A36, N2882W, was substantially damaged when it was involved in an accident near Olympic Valley, California. The pilot was fatally injured. The airplane was operated as a Title14 Code of Federal…NTSB ANC26FA021Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Boynton Beach, FLOn March 23, 2026, about 1221 eastern daylight time, a Robinson R44 Raven I helicopter, N478AT, was destroyed when it was involved in an accident near Boynton Beach, Florida. The flight instructor and the pilot receiving instruction were fatally injured. The…NTSB CEN26FA142Accident · 1 fatalClass 3 · FieldPreliminary reportBeechcraft B200GT · Sharp, LAOn March 22, 2026, at 1418 central daylight time (CDT), a Beechcraft B200GT (Super King Air) airplane, N886DS, was destroyed when it was involved in an accident near Sharp, Louisiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB GAA26WA135Accident · 2 fatalClass 5 · ForeignCessna 152 · Amazonas, BrazilNTSB CEN26FA141Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-140 · Rock Falls, ILOn March 20, 2026, about 1503 central daylight time, a Piper PA-28-140 airplane, N9913W, was destroyed when it was involved in an accident near Rock Falls, Illinois. The student pilot sustained fatal injuries. The airplane was being operated as a Title 14…NTSB GAA26WA154Accident · Serious injuriesClass 5 · ForeignCessna 441 · Djugun, AustraliaNTSB CEN26FA140Accident · 1 fatalClass 3 · FieldPreliminary reportAero Commander 500-B · Chesterfield, MOOn March 17, 2026, about 0024 central daylight time, an Aero Commander 500-B airplane, N444CA, was destroyed when it was involved in an accident near Chesterfield, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA136Accident · Serious injuriesClass 5 · ForeignAdams Balloon A55S · Teotihuacan, MexicoNTSB GAA26WA129Accident · 4 fatalClass 5 · ForeignCessna 182 · San Marcos, GuatemalaNTSB GAA26WA127Accident · No injuriesClass 5 · ForeignAir Tractor AT401 · Tiquisate, GuatemalaNTSB GAA26WA257Accident · 1 fatalClass 5 · ForeignVans RV14 · Cima di Lago, SwitzerlandNTSB GAA26WA128Accident · Serious injuriesClass 5 · ForeignCessna U206 · Tanque, Costa RicaNTSB GAA26WA132Accident · No injuriesClass 5 · ForeignCessna 170 · San Rafael, ArgentinaNTSB GAA26WA125Occurrence · No injuriesClass 5 · ForeignPiper PA-28-181 · Goose Bay, GreenlandNTSB GAA26WA146Incident · No injuriesClass 5 · ForeignBeech 95B55 · Salamanca, SpainNTSB GAA26WA124Accident · 1 fatalClass 5 · ForeignThrush S2R · La Lima, HondurasNTSB ERA26LA140Accident · 2 fatalClass 3 · LimitedPreliminary reportBeech A36 · Gulf Shores, ALOn March 7, 2026, about 1900 central standard time, a Beechcraft A36, N66519 was destroyed when it was involved in an accident near Gulf Shores, Alabama. The pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA26WA123IncidentClass 5 · ForeignSikorsky S92 · Aberdeen, United KingdomNTSB CEN26FA132Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T210M · Deerfield, ILOn March 4, 2026, about 2145 central standard time, a Cessna T210M airplane, N19FB sustained substantial damage when it was involved in an accident near Deerfield, Illinois. The pilot was fatally injured. The airplane was operated under Title 14 Code of…NTSB WPR26FA109Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · Oroville, CAOn February 28, 2026, about 0948 Pacific standard time, a Piper PA-22-150, N3170Z, was destroyed when it was involved in an accident near Oroville, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR26FA108Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-8 · Hurricane, UTOn February 28, 2026, at about 1005 mountain standard time, an experimental amateur-built, Vans Aircraft, RV-8, N80AR, was substantially damaged when it was involved in an accident near Hurricane, Utah. The pilot was fatally injured. The airplane was operated…NTSB GAA26WA119Accident · No injuriesClass 5 · ForeignCessna 150 · Gosport, United KingdomNTSB GAA26WA122Accident · No injuriesClass 5 · ForeignPiper PA36 · Zona Rural, Jesús María, Córdoba, BrazilNTSB GAA26WA118Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Wesselsbron, South AfricaNTSB ERA26FA120Accident · Serious injuriesClass 3 · FieldPreliminary reportAirbus Helicopters EC 130 T2 · Evergreen, ALOn February 22, 2026, at 1510 central standard time, an Airbus EC130 T2 helicopter, N237SH, was substantially damaged when it was involved in an accident near Evergreen, Alabama. The commercial pilot and two medical crewmembers were seriously injured. The…NTSB GAA26WA117Accident · 3 fatalClass 5 · ForeignRobinson R44 · Amaranka, RussiaNTSB GAA26WA112AccidentForeign investigationCessna 150 · Ripon, United KingdomNTSB GAA26WA109Accident · No injuriesClass 5 · ForeignCessna 150 · Mendoza Chico, UruguayNTSB GAA26WA113Accident · No injuriesClass 5 · ForeignRobinson R44 · Algés, PortugalNTSB GAA26WA126Accident · No injuriesForeign investigationRobin DR400 · Quimper, FranceNTSB GAA26WA107Accident · No injuriesClass 5 · ForeignPiper PA36 · Blanca Piedra, EcuadorNTSB ERA26FA114Accident · 1 fatalClass 3 · FieldPreliminary reportTailwind W-8 · Poplar Grove, ILOn February 14, 2026, about 1600 central standard time, an experimental, amateur-built Tailwind W-8 airplane, N9424H, was destroyed when it was involved in an accident near Poplar Grove, Illinois. The pilot was fatally injured. The airplane was operated as a…NTSB GAA26WA105Accident · Minor injuriesClass 5 · ForeignHughes 369 · Conques sur Orbiel, FranceNTSB GAA26WA103Accident · No injuriesClass 5 · ForeignPiper PA34 · Palmira, ColombiaNTSB GAA26WA148Accident · Serious injuriesClass 5 · ForeignRobinson R22 · Quambone, AustraliaNTSB GAA26WA147AccidentClass 5 · ForeignSocata TBM700 · Leuzigen, SwitzerlandNTSB WPR26FA098Accident · 2 fatalClass 3 · FieldPreliminary reportBell 407 · Flagstaff, AZOn February 4, 2026, at 2216 mountain standard time, a Bell 407 helicopter, N56AZ, was substantially damaged when it was involved in an accident near Flagstaff, Arizona. The pilot and tactical flight officer (TFO) were fatally injured. The helicopter was…NTSB GAA26WA088Accident · 2 fatalClass 5 · ForeignCirrus SR20 · Greater Manchester, United KingdomNTSB GAA26WA094Accident · No injuriesClass 5 · ForeignPiper PA46R · Campo Grande, BrazilNTSB GAA26WA095Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Taquarussu, BrazilNTSB GAA26WA337Accident · Serious injuriesForeign investigationCessna 150 · Santiago, ChileNTSB GAA26WA085Accident · 5 fatalClass 3 · ForeignLearjet 45XR · Sawantwadi, IndiaNTSB GAA26WA087Accident · 2 fatalClass 5 · ForeignHughes 269C · Paekakariki Hill, New ZealandNTSB GAA26WA082Accident · 3 fatalClass 5 · ForeignCessna 172 · Comunidad Wichimi, Ecuador