NTSB investigations
1,858 cases where the sequence of events included Loss of engine power (partial).
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\" = '342' 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" = '342' 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 ERA26LA183Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 421 · Richmond, VAOn April 18, 2026, about 1410 eastern daylight time, a Cessna 421C, C-GTGR, was substantially damaged when it was involved in an accident near Richmond, Virginia. The pilot and four passengers were uninjured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA169Accident · Serious injuriesClass 3 · LimitedPreliminary reportEric Vargosko SW-51 · Iron Station, NCOn April 10, 2026, about 1732 eastern daylight time, an experimental amateur built SW-51 airplane, N551EV, sustained minor damage when it was involved in an accident near Iron Station, North Carolina. The front seat pilot sustained minor injuries, and the…NTSB ERA26LA162Accident · No injuriesClass 3 · LimitedPreliminary reportGirardeau Samuel G Sonex-A · Martinsburg, WVOn April 4, 2026, about 1339 eastern daylight time, a Girardeau Samuel G Sonex-A airplane, N106D, was substantially damaged when it was involved in an accident near Martinsburg, WV. The pilot and passenger were not injured. The aircraft was operated as a…NTSB ANC26LA029Accident · No injuriesClass 3 · LimitedPreliminary reportMaule M-7-235 · Wasilla, AKOn April 3, 2026, at 1300 Alaska daylight time, a Maule M 7 235 airplane, N93ML, was substantially damaged during an accident near Wasilla, Alaska. The pilot and one passenger were not injured. The airplane was operated as a personal flight under the…NTSB WPR26LA132Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · West Valley City, UTOn March 21, 2026, about 1610 mountain daylight time, a Piper PA-28-140, N7328J, was substantially damaged when it was involved in an accident near West Valley City, Utah. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…NTSB CEN26LA143Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172P · Denton, TXOn March 20, 2026, about 1415 central daylight time, a Cessna 172P airplane, N65614, was substantially damaged when it was involved in an accident near Denton, Texas. The pilot sustained minor injuries, and the pilot-rated sensor operator sustained serious…NTSB DCA26WA154Incident · No injuriesClass 5 · ForeignBoeing 747 · Almaty, KazakhstanNTSB ERA26LA144Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Indian Trail, NCOn March 8, 2026, about 1100 eastern daylight time, a Piper PA-28-140, N98360, was substantially damaged when it was involved in an accident near Indian Trail, North Carolina. The pilot and passenger were seriously injured. The airplane was operated as a…NTSB WPR26FA119Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-28-140 · Phoenix, AZOn March 4, 2026, about 0721 mountain standard time, a Piper PA-28-140, N7744T, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor was seriously injured, and the student pilot and one person on the…NTSB ANC26LA016Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 177B · Rocky Junction, AZOn February 21, 2026, 1746 Mountain standard time, a Cessna 177B airplane, N12984, was substantially damaged when it was involved in an accident near Rocky Junction, Arizona. The pilot and passenger sustain minor injuries. The airplane was operated as a Title…NTSB GAA26WA092Accident · No injuriesClass 5 · ForeignPiper PA31 · Las Cayes, HaitiNTSB ANC26LA013Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-22-150 · Anchorage, AKOn January 31, 2026, about 1921 Alaska standard time, a Piper PA-22-150 airplane, N3263Z, was substantially damaged when it was involved in an accident near Anchorage, Alaska. The pilot was uninjured, and the passenger was transported to the hospital with…NTSB GAA26WA114AccidentClass 5 · ForeignRobinson R44 · Hamilton Island, AustraliaNTSB CEN26LA100Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA 46-350P · Sioux City, IAOn January 24, 2026, about 0712 central daylight time, a Piper PA-46-350P airplane, N91MK, was substantially damaged when it was involved in an accident near Sioux City, Iowa. The pilot and passenger were uninjured. The airplane was operated as a Title 14…NTSB GAA26WA093Accident · No injuriesClass 5 · ForeignPiper PA-28-181 · Lelystad, NetherlandsNTSB CEN26LA097Accident · No injuriesClass 3 · LimitedPreliminary reportQuicksilver II · Spring, TXOn January 20,2026, 1658 central standard time, a Quicksilver II, N4NH, sustained substantial damage when it was involved in an accident at David Wayne Hooks Memorial Airport, DWH, in Spring, Texas. The pilot, sole occupant, sustained no injuries. The…NTSB CEN26LA087Accident · Minor injuriesClass 3 · LimitedPreliminary reportStinson 108-3 · Gypsum, COOn January 11, 2026, at 1408 mountain standard time, a Stinson 108-3 airplane, N6725M, sustained substantial damage when it was involved in an accident near Gypsum, Colorado. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB GAA26WA076Accident · No injuriesClass 5 · ForeignBell 206 · Queensland, AustraliaNTSB WPR26LA073Accident · No injuriesClass 3 · LimitedPreliminary reportEvektor - Aerotechnik A S Sportstar MAX · Needles, CAOn December 27, 2025, about 1109 Pacific standard time, an Evektor-Aerotechnik AS Sportstar Max LSA airplane, N2312T, was substantially damaged when it was involved in an accident near Needles, California. The pilot and pilot rated passenger were not injured.…NTSB WPR26FA068Accident · 1 fatalClass 3 · FieldPreliminary reportBeech K35 · Summer Lake, OROn December 23, 2025, about 0841 Pacific standard time, a Beech K35, N9540R, was substantially damaged when it was involved in an accident near Summer Lake, Oregon. The pilot was fatally injured. The airplane was being operated as a Title 14 Code of Federal…NTSB WPR26LA060Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeechcraft G36 · Tracy, CAOn December 15, 2025, about 1526 Pacific standard time, a Beechcraft G36, N360FV, was substantially damaged when it was involved in an accident near Tracy, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA056Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec · Lake Havasu City, AZThe pilot’s improper securing hardware installation, which resulted in a loss of throttle control and a loss of engine power.NTSB GAA26WA036Accident · No injuriesClass 5 · ForeignBeech E90 · Para De Minas, BrazilNTSB GAA26WA031Accident · No injuriesClass 5 · ForeignBell 206 · Uruyen, VenezuelaNTSB ERA26LA046Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Palm Bay, FLOn November 17, 2025, about 1900 eastern standard time, a Cessna 172N, N6124D, was substantially damaged when it was involved in an accident near Palm Bay, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB WPR26LA045Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Mesa, AZOn November 17, 2025, about 0830 mountain standard time, a Piper PA 28-181, N4402N, was substantially damaged when it was involved in an accident near Mesa, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…NTSB ENG26WA010OccurrenceClass 5 · ForeignDe Havilland DHC3 · Lake Rotorua, New ZealandNTSB ENG26WA007OccurrenceClass 5 · ForeignAirbus A321 · Mexico City, MexicoNTSB DCA26WA029Incident · No injuriesClass 5 · ForeignMcdonnell Douglas MD88 · Mashhad, IranNTSB DCA26FA019Accident · No injuriesClass 4 · FieldFinal reportAir Vev AIR ZERO2 · Indiantown, FLA cascading shutoff of multiple aft motors due to a sudden increase in motor loads during maneuvering, resulting in a loss of control.NTSB GAA26WA023Accident · No injuriesClass 5 · ForeignGuimbal Cabri · Locarno, SwitzerlandNTSB WPR26LA022Accident · Minor injuriesClass 3 · LimitedPreliminary reportFlight Design Ctsw · Casa Grande, AZOn October 17, 2025, about 13:20 mountain standard time, a Flight Design GMBH CTSW, N531CT, was substantially damaged when it was involved in an accident near Casa Grande, Arizona. The pilot received minor injuries. The airplane was operated as a Title 14…NTSB WPR26LA020Accident · 3 fatalClass 3 · LimitedPreliminary reportPiper PA-23-250 · Condon, MTOn October 17, 2025, about 1615 mountain daylight time, a Piper PA-23-250, N2345R, was substantially damaged when it was involved in an accident near Condon, Montana. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14…NTSB GAA26WA018Accident · No injuriesClass 5 · ForeignRobinson R22 · Colombo, BrazilNTSB ERA26LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · North Lauderdale, FLA total loss of engine power due to a fuel delivery system leak, which allowed air to enter the fuel system. The source of the leak could not be determined based on the available evidence.NTSB ERA26LA012Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Sandersville, GAOn October 10, 2025, about 2015 eastern daylight time, a Cessna 172G, N4390L, was substantially damaged when it was involved in an accident near Sandersville, Geogia. The pilot was not injured and the passenger sustained minor injuries. The airplane was…NTSB ERA26LA007Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Miami, FLOn October 07, 2025, at 1440 eastern daylight time, a Cessna 172M, N433PT, was substantially damaged when it was involved in an accident near Miami, Florida. The private pilot and the flight instructor were uninjured. The airplane was operated as a Title 14…NTSB CEN26LA006Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · McGregor, MNOn October 5, 2025, about 1310 central daylight time, a Piper PA-28-140, N4218T was substantially damaged when it was involved in an accident near McGregor, Minnesota. The pilot and two passengers were seriously injured. The airplane was operated under the…NTSB GAA26WA002Accident · No injuriesClass 3 · ForeignCirrus SR22 · Al-Maktoum, United Arab EmiratesNTSB ERA25LA369Accident · No injuriesClass 3 · LimitedPreliminary reportGregory A Spicola AR-1 · Fort Myers, FLOn September 28, 2025, about 1000 EST, a Spicola AR-1 gyroplane, N107AR, was substantially damaged when it was involved in an accident at Buckingham Field Airport (FL59), Lehigh Acres, Florida. The commercial pilot and pilot-rated passenger were not injured.…NTSB ERA25LA368Accident · No injuriesClass 3 · LimitedPreliminary reportElmore Travis C Searey · Rotonda West, FLOn September 28, 2025, at 1126 eastern daylight time, an experimental, amateur-built Searey, N2090S, was substantially damaged when it was involved in an accident near Stump Pass, Florida. The private pilot sustained minor injuries. The airplane was operated…NTSB CEN25LA386Accident · No injuriesClass 3 · LimitedPreliminary reportMooney M20K · Pearland, TXOn September 16, 2025, about 1040 central daylight time, a Mooney Aircraft Corp. M20K, N305EP was substantially damaged when it was involved in an accident at the Pearland Regional Airport, Pearland, Texas. The pilot and certificated flight instructor were…NTSB GAA25WA257Accident · No injuriesClass 5 · ForeignVulcanair P68 · Antofagasta, ChileNTSB GAA25WA256Accident · No injuriesClass 5 · ForeignCessna 150 · Montevideo, UruguayNTSB DCA25WA331Incident · No injuriesClass 5 · ForeignBoeing 737 · Barquisimeto, VenezuelaNTSB DCA25WA321Incident · No injuriesClass 5 · ForeignBoeing 737-832 · Belize City, BelizeNTSB ERA25LA346Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-24-180 · Ashland City, TNOn September 5, 2025, at 1645 central daylight time, N5759P, a Piper Cherokee PA-24-180, sustained substantial damage when it was involved in an accident near Ashland City, Tennessee. The private pilot sustained minor injuries. The flight was conducted as a…NTSB GAA25WA274Accident · Minor injuriesClass 5 · ForeignBeech A36 · Guarantã Do Norte, BrazilNTSB GAA25WA249Accident · Serious injuriesClass 5 · ForeignBell 206 · Cali, ColombiaNTSB CEN25LA360Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172H · Goliad, TXOn August 27, 2025, about 1904 central daylight time, a Cessna 172H airplane, N8078L, was substantially damaged when it was involved in an accident near Goliad, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…