NTSB investigations
2,825 cases where the defining event was Loss of engine power (total).
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '341') 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 GAA25WA246Accident · No injuriesClass 5 · ForeignRockwell 112 · Sanat Ana del Yacuma, BoliviaNTSB ANC25LA091Accident · No injuriesClass 3 · LimitedPreliminary reportVu Holdings LLC/DBA Vanilla UN VA 001 · Ninilchik, AKOn August 20, 2025, at about 0632 Alaska daylight time, a Platform Aerospace VA 001 Unmanned Aerial System (UAS), N246VU, was substantially damaged when it was involved in an accident on a beachside cliff near Ninilchik, Alaska. The aircraft was unmanned. The…NTSB CEN25LA327Accident · Minor injuriesClass 3 · LimitedPreliminary reportMarshall Allen L RV6A · Centerview, MOOn August 19, 2025, at 1640 central daylight time, a Vans RV-6A airplane, N692AC, was substantially damaged when it was involved in an accident near Centerview, Missouri. The commercial pilot sustained minor injuries and the passenger was uninjured. The…NTSB WPR25LA267Accident · No injuriesClass 3 · LimitedPreliminary reportDavid Ullman Jabirwatt · Albany, OROn August 18, 2025, about 1300 Pacific daylight time, an experimental amateur-built Jabirwatt, N824DW, was substantially damaged when it was involved in an accident near Albany, Oregon. The pilot was not injured. The airplane was operated as a Title 14 Code…NTSB GAA25WA245Accident · No injuriesClass 5 · ForeignEmbraer EMB721 · Cano Negro, BoliviaNTSB CEN25LA323Accident · No injuriesClass 3 · LimitedPreliminary reportGrumman American Avn. G-164B · Fowler, INOn August 15, 2025, about 1910 eastern daylight time, a Grumman American Avn. Corp. G-164-B airplane, N7015N, was substantially damaged when it was involved in an accident near Fowler, Indiana. The pilot was not injured. The airplane was operated under Title…NTSB CEN25LA322Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · Joliet, ILThe failure of the No. 2 cylinder exhaust valve, which resulted in a total loss of engine power.NTSB CEN25LA317Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210 · Zapata, TXOn August 13, 2025, about 1835 central daylight time, a Cessna P210N airplane, N92MS, was substantially damaged when it was involved in an accident near Zapata, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA25LA297Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Ponce Inlet, FLOn August 11, 2024, about 1359 easter daylight time, a Piper PA-12, N2504M, was substantially damaged when it was involved in an accident near Ponce Inlet, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA25LA294Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-151 · Chamblee, GAOn August 9, 2025, about 0033 eastern daylight time, a Piper PA-28-151, N1080H, was substantially damaged when it was involved in an accident near DeKalb-Peachtree Airport (PDK), Chamblee, Georgia. The flight instructor and student pilot were seriously…NTSB ERA25LA307Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Wirt County, WVOn August 8, 2025, about 1757 eastern daylight time, a Beech A36, N60357, was substantially damaged when it was involved in an accident in Wirt County, West Virginia. The commercial pilot and three passengers were not injured. The airplane was operated as a…NTSB WPR25LA244Accident · Serious injuriesClass 3 · LimitedPreliminary reportNorth American T-28C · West Wendover, NVOn August 07, 2025, at 1532 Pacific daylight time, a North American T-28C, N9748Y, was substantially damaged when it was involved in an accident near West Wendover, Utah. The pilot and the passenger were seriously injured. The airplane was operated as a Title…NTSB CEN25LA310Accident · Serious injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Jaroso, COOn August 7, 2025 at 0935 mountain daylight time, a Cirrus SR22 airplane, N412DJ, was substantially damaged when it was involved in an accident near Jaroso, Colorado. The pilot receiving instruction and a passenger were seriously injured, and the flight…NTSB CEN25LA306Accident · Serious injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-301 · Davenport, NDOn August 6, 2025, at 2035 central daylight time, an Air Tractor Inc AT-301 airplane, N23069, was substantially damaged when it was involved in an accident near Davenport, North Dakota. The commercial pilot sustained serious injuries. The airplane was…NTSB CEN25LA305Accident · No injuriesClass 3 · LimitedPreliminary reportStolp Starduster SA300 · Marshall, AROn August 6, 2025 about 1552 central daylight time, a Stolp Starduster SA 300 airplane was substantially damaged when it was involved in an accident near Marshall, Arkansas. The pilot was not injured. The airplane was operated under the provisions of Title 14…NTSB ERA25LA288Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Pembroke Pines, FLOn August 05, 2025, about 0820 eastern daylight time, a Cessna 172N, N1213F, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a…NTSB GAA25WA224Accident · No injuriesClass 5 · ForeignCessna 188 · Guayabal-Meta, ColombiaNTSB ERA25LA289Accident · Minor injuriesClass 3 · LimitedPreliminary reportJabiru Aircraft PTY J230-D · Oak Island, NCOn August 2, 2025, about 1925 eastern daylight time, a Jabiru Aircraft Pty Ltd J-230-D, N784J, was substantially damaged when it was involved in an accident near Oak Island, North Carolina. The private pilot received minor injuries. The airplane was operated…NTSB ERA25FA283Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J5C · Rochester, NYOn August 1, 2025, about 1330 eastern daylight time, a Piper J5C, NC 28151, was substantially damaged when it was involved in an accident near Rochester, New York. The passenger was fatally injured, and the pilot was seriously injured. The airplane was…NTSB CEN25LA300Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172P · Gainesville, TXOn August 1, 2025, about 0802 central daylight time, a Cessna 172P airplane, N62296, was substantially damaged during an accident near Gainesville, Texas. The flight instructor and pilot-receiving-instruction were not injured. The airplane was operated as a…NTSB GAA25WA228Accident · No injuriesClass 3 · ForeignPiper PA32 · Marsh Harbor, BahamasNTSB GAA25WA221Accident · 1 fatalClass 5 · ForeignGrumman AA5 · Ottawa, Ontario, CanadaNTSB ERA25LA281Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Kissimmee, FLOn July 30, 2025, at 11:28 eastern daylight time, a Cessna 172S, N121CW, was substantially damaged when it was involved in an accident near Kissimmee, Florida. The private pilot and flight instructor were uninjured. The airplane was operated as a Title 14…NTSB ERA25LA278Accident · Minor injuriesClass 3 · LimitedPreliminary reportOrlican S R O M-8 Eagle · Lake Worth Beach, FLOn July 28, 2025, about 16:24 eastern daylight time, an Orlican M-8, N974FL, was substantially damaged when it was involved in an accident near Lake Worth Beach, Florida. The flight instructor sustained minor injuries, the private pilot sustained no injuries,…NTSB CEN25LA297Accident · Serious injuriesClass 3 · LimitedPreliminary reportAyres S2R · Akron, IAOn July 28, 2025, about 1537 central daylight time, an Ayres Corporation S2R-T34 airplane, N524SL, sustained substantial damage when it was involved in an accident near Akron, Iowa. The pilot sustained serious injuries. The airplane was operated as a Title 14…NTSB CEN25LA291Accident · No injuriesClass 3 · LimitedPreliminary reportMatesi Eugene E Lancair 320 · Wink, TXOn July 27, 2025, about 2001 central daylight time, a Lancair 320 airplane, N70337, was substantially damaged when it was involved in an accident near Wink, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR25LA230Accident · Minor injuriesClass 3 · LimitedPreliminary reportBallisodare Lancair Evolution · Coeur d' Alene, IDOn July 27, 2025, about 1010 Pacific daylight time, an experimental amateur-built Lancair Evolution airplane, N505RF, was destroyed when it was involved in an accident near Coeur d’Alene, Idaho. The pilot and two passengers sustained minor injuries. The…NTSB GAA25WA229Accident · No injuriesClass 5 · ForeignCessna 150 · BragançA Paulista, BrazilNTSB ERA25LA277Accident · Minor injuriesClass 3 · LimitedPreliminary reportMangels Leighton LANCAIR360 · Hardinsburg, KYOn July 24, 2025, about 1000 central daylight time, an experimental amateur-built Lancair 360, N50LM, was substantially damaged when it was involved in an accident near Hardinsburg, Kentucky. The pilot and the passenger sustained minor injuries. The airplane…NTSB CEN25LA277Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R66 · Maynard, IAOn July 22, 2025, about 1400 central daylight time, a Robinson Helicopter Company R66 helicopter, N88911, was substantially damaged when it was involved in an accident near Maynard, Iowa. The pilot was uninjured. The helicopter was operated under Title 14…NTSB CEN25LA282Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T210N · Crosby, TXOn July 21, 2025, about 0745 central daylight time, a Cessna T210N, N93HP, was substantially damaged when it was involved in an accident near Crosby, Texas. The pilot and passenger were not injured. The airplane operated as a Title 14 Code of Federal…NTSB CEN25FA269Accident · 1 fatalClass 3 · FieldPreliminary reportAero Vodochody L-39C · Granite Falls, MNOn July 21, 2025, about 1728 central daylight time, an Aero Vodochody L-39C airplane, N339L, was substantially damaged during an accident near Granite Falls, Minnesota. The flight instructor, seated in the front seat, sustained serious injuries after ejecting…NTSB ENG25WA056AccidentClass 5 · ForeignAgustaWestlands AW119 Mkii · Britânia, state of Goiás, BrazilNTSB ENG25WA047Accident · No injuriesClass 5 · ForeignViking DHC-2 MK. I (Beaver) · Lac du Poisson Blanc, CanadaNTSB WPR25LA218Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 425 · Round Rock, AZOn July 17, 2025, about 1600 mountain daylight time, a Cessna 425, N425D, was substantially damaged when it was involved in an accident near Round Rock, Arizona. The pilot receiving instruction and the flight instructor were not injured. The airplane was…NTSB WPR25FA213Accident · 1 fatalClass 3 · FieldPreliminary reportScott Macwilliam SR3500 Moose · Quinault, WAOn July 15, 2025, at about 1440 Pacific daylight time, an experimental amateur-built Murphy Moose SR3500 airplane, N80TM, sustained substantial damage when it was involved in an accident near Quinault, Washington. The pilot received minor injuries, one…NTSB ERA25LA265Accident · Serious injuriesClass 3 · LimitedPreliminary reportMoyes Liteflite PTY C Dragonfly · Charlestown, NHOn July 13, 2025, about 1915 eastern daylight time, a Moyes Liteflite Model C Dragonfly airplane, N4010E, was substantially damaged when it was involved in an accident near Charleston, New Hampshire. The pilot was seriously injured. The airplane was operated…NTSB DCA25WA262IncidentClass 5 · ForeignAirbus A320-232 · Nassau, BahamasNTSB GAA25WA223Accident · 3 fatalClass 5 · ForeignRobin DR400 · Voglans, FranceNTSB GAA25WA210Accident · 1 fatalClass 5 · ForeignJodel DR1050 · Châteauroux-Villers, FranceNTSB GAA25WA209AccidentClass 5 · ForeignCirrus Design SR22 · Ploski, BulgariaNTSB CEN25LA225Accident · No injuriesClass 3 · LimitedFinal reportTecnam P2010 · Temple, TXThe loss of engine power due to a failed muffler flame tube assembly which resulted in an exhaust blockage.NTSB WPR25LA188Accident · Minor injuriesClass 3 · LimitedPreliminary reportFilby Gerry RV-9 · Morgan Hill, CAOn June 23, 2025, about 1217 Pacific daylight time, an experimental amateur-built Vans Aircraft Inc RV-9 airplane, N696WG, was substantially damaged when it was involved in an accident near Morgan Hill, California. The pilot sustained minor injuries. The…NTSB GAA25WA189Accident · Minor injuriesClass 5 · ForeignBensen B8M · Taghmon, IrelandNTSB WPR25LA174Accident · Serious injuriesClass 3 · LimitedPreliminary reportQuitter John F MXL II · Acampo, CAOn June 14, 2025, about 1511 Pacific daylight time, an experimental MXL II, N375ME, was substantially damaged when it was involved in an accident near Acampo, California. The pilot was uninjured, and the passenger was seriously injured. The airplane was…NTSB ERA25LA234Accident · Minor injuriesClass 3 · LimitedPreliminary reportSteven Scott Grasley RV-7A · Interlachen, FLOn June 13, 2025, about 15:31 eastern daylight time, an experimental, amateur built RV-7A, N783RV, was substantially damaged when it was involved in an accident near Interlachen, Florida. The commercial pilot received minor injuries. The airplane was operated…NTSB ERA25LA227Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Hartsville, TNOn June 12, 2025, about 1750 central daylight time, a Cirrus SR22, N312DA, was substantially damaged when it was involved in an accident near Hartsville, Tennessee. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA25WA200Accident · No injuriesClass 5 · ForeignRobinson R44 · Venn, AustraliaNTSB GAA25WA181Accident · No injuriesClass 5 · ForeignPulsar XP · Bromsgrove, United KingdomNTSB CEN25LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mineral Wells, TXThe pilot’s improper fuel tank selection prior to takeoff, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the airplane checklist.