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 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.NTSB GAA24WA241AccidentClass 5 · ForeignRobinson 44 · Torun Wloscianski, PolandNTSB WPR24LA259Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C23 · Elko, NVA total loss of engine power for reasons that could not be determined.NTSB GAA24WA229Accident · 2 fatalClass 5 · ForeignCessna 150 · Yorkshire, United KingdomNTSB GAA24WA234Accident · No injuriesClass 5 · ForeignEurocopter AS 350 B2 Ecureuil · Laredo/Border, MexicoNTSB DCA24WA247Incident · No injuriesClass 5 · ForeignBoeing 737 · Yola, NigeriaNTSB ERA24FA309Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 208 · Youngstown, NYOn July 20, 2024, about 1140 eastern daylight time, a Cessna 208B, N1259K, was destroyed when it was involved in an accident near Youngstown, New York. The commercial pilot was fatally injured. The airplane was operated by Skydive the Falls as a Title 14 Code…NTSB GAA24WA258Accident · 3 fatalClass 5 · ForeignCessna 421C · Tofino, CanadaNTSB GAA24WA256Accident · 2 fatalClass 5 · ForeignPiper PA34 · Carate, Costa RicaNTSB GAA24WA313Accident · 1 fatalClass 5 · ForeignExtra 200 · Northamptonshire, United KingdomNTSB ERA24FA304Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT802 · Cuba, KYImpact with terrain for reasons that could not be determined.NTSB ANC24LA064Accident · No injuriesClass 3 · LimitedFinal reportDehavilland DHC-2T · Petersville, AKAn in-flight loss of thrust due to an uncommanded feathering of the propeller for reasons that could not be determined.NTSB ERA24FA300Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Palm Beach Gardens, FLA loss of engine power for reasons that could not be determined.NTSB GAA24WA217Accident · No injuriesClass 5 · ForeignBell 212 · Fort McMurray, CanadaNTSB CEN24LA249Accident · No injuriesClass 3 · LimitedFinal reportRotorway 162 F · Maybee, MIA partial loss of engine power for undetermined reasons.NTSB CEN24LA245Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon A36 · Land O' Lakes, WIA partial loss of engine power for undetermined reasons.NTSB GAA24WA202Accident · 1 fatalClass 5 · ForeignStearman A75 · Hasselt, Belgium