NTSB investigations
3,824 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' 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" = '341' 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 CEN26LA252Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Whiting, KSThe pilot's failure to maintain clearance from an antenna while maneuvering during a low-level aerial application flight.NTSB DCA26WA280Incident · No injuriesClass 5 · ForeignBoeing 767 · Manta, EcuadorNTSB CEN26LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Ellsworth, KSThe pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to complete the flight.NTSB ANC26LA070Accident · Minor injuriesClass 3 · LimitedPreliminary reportMooney M20M · Tallahassee, FLOn July 8, 2026, at 1148 eastern daylight time, a Mooney M20 airplane was substantially damaged when it was involved in an accident near Tallahassee, Florida. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA251Accident · No injuriesClass 3 · LimitedPreliminary reportLuscombe 8A · Novato, CAOn July 7, 2026, about 1200 Pacific daylight time, a Luscombe 8A, N45886, was substantially damaged when it was involved in an accident near Novato, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA246Accident · Minor injuriesClass 4 · LimitedFinal reportRotec Engineering Rally 3 · Hooker, OKThe total loss of engine power due to an engine seizure for undetermined reasons because the wreckage was disposed of before it could be examined.NTSB ANC26LA069Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-18-150 · Mekoryuk, AKOn July 7, 2026 about 1430 Alaska daylight time, a Piper PA-18-150 airplane, N824JT, was substantially damaged when it was involved in an accident near Mekoryuk, Alaska. The pilot and one passenger were not injured. The airplane was operated as a Title 14…NTSB WPR26LA245Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Salome, AZOn July 5, 2026, at about 0825 Pacific daylight time, a Piper PA-28-140, N3995K, was substantially damaged when it was involved in an accident near Salome, Arizona. The pilot and passenger were uninjured. The airplane was operating as a Title 14 Code of…NTSB ERA26LA257Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Lafayette, TNOn July 2, 2026, at 1032 central daylight time, a Cirrus Design Corp SR22, N127DC, was substantially damaged when it was involved in an accident near Lafayette, Tennessee. The pilot and passenger sustained no injuries. The airplane was operated as a Title 14…NTSB CEN26FA241Accident · Serious injuriesClass 3 · FieldPreliminary reportBeech 95-A55 · Lancaster, SCOn July 2, 2026, at 0052 eastern daylight time (EDT), a Beech model 95-A55 airplane, N7501S, was destroyed when it was involved in an accident near Lancaster, South Carolina. Both pilots received serious injuries. The accident flight was operated as a Title…NTSB WPR26LA237Accident · Serious injuriesClass 3 · LimitedPreliminary reportAutogyro MT03 · San Jose, CAOn June 29, 2026, about 1148 Pacific daylight Time, a MTO Sport gyroplane, N423AG, was substantially damaged when it was involved in an accident at Reid-Hillview Airport (RHV), San Jose, California. The pilot was seriously injured, and the passenger received…NTSB GAA26WA240Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Moncoes, BrazilNTSB WPR26LA235Accident · No injuriesClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA20-C1 · Nephi, UTOn June 25, 2026, about 0905 mountain daylight time, a Diamond DA20-C1, N643DC, was substantially damaged when it was involved in an accident near Nephi, Utah. The flight instructor and the student pilot were not injured. The airplane was operated as a Title…NTSB DCA26WA269Incident · No injuriesClass 5 · ForeignBoeing 767 · Callao, PeruNTSB ANC26LA063Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Windom, WVOn June 21, 2026, about 1132 eastern daylight time, a Cirrus SR22 airplane, N544CD, was substantially damaged when it was involved in an accident near Windom, West Virginia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA26WA221Accident · No injuriesClass 5 · ForeignPiper PA24 · General Roca, ArgentinaNTSB CEN26FA228Accident · 1 fatalClass 3 · FieldPreliminary reportTextron 680A · Laredo, TXOn June 16, 2026, at 2200 central daylight time, a Textron Aviation Inc 680A, N523QS, sustained substantial damage when it was involved in an accident in Laredo, Texas. The captain received serious injuries, the first officer received minor injuries, one…NTSB CEN26LA225Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Meridian, MSThe total loss of power to both engines due to fuel exhaustion. Contributing to the accident was the pilot’s failure to verify the airplane’s fuel quantity before departure.NTSB WPR26LA211Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-44-180T · St. George, UTOn June 7, 2026, about 1012 mountain standard time, a Piper PA-44-180T, N8390K, was substantially damaged when it was involved in an accident near St. George, Utah. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA231Accident · Serious injuriesClass 3 · LimitedPreliminary reportOlson/Williams Sonex · Jaffrey, NHOn June 5, 2026, at 1100 eastern daylight time, an experimental amateur-built Sonex airplane, N28YD, was substantially damaged when it was involved in an accident near Jaffrey, New Hampshire. The private pilot was seriously injured. The flight was conducted…NTSB CEN26LA218Accident · No injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-602 · Breaux Bridge, LAOn June 3, 2026, about 1320 central daylight time, an Air Tractor AT-602 airplane, N50050, was substantially damaged when it was involved in an accident near Breaux Bridge, Louisiana. The pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA225Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper J5C-65 · East Granby, CTOn June 2, 2026, at 1151 eastern daylight time, a Piper J3C-65, N331JM, was substantially damaged when it was involved in an accident near East Granby, Connecticut. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA209Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Casper, WYOn June 1, 2026, about 1340 mountain daylight time, a Cirrus Design Corp SR22T, N324WY, was substantially damaged when it was involved in an accident near Casper, Wyoming. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA211Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Montevideo, MNA total loss of engine power on approach due to carburetor icing.NTSB WPR26LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-602 · Robbins, CAOn May 30, 2026, about 0900 Pacific daylight time, an Air Tractor AT-602, N5111A, was substantially damaged when it was involved in an accident near Robbins, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26LA223Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T210 · Loíza, PROn May 30, 2026, about 0744 Atlantic standard time, a Cessna T210, N210PL, was substantially damaged when it was involved in an accident near Loiza, Puerto Rico. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA208Accident · Minor injuriesClass 3 · LimitedPreliminary reportAmerican AA-1A · Amery, WIOn May 30, 2026, about 1113 central daylight time, a Grumman AA-1A airplane, N6416L, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26LA224Accident · Serious injuriesClass 3 · LimitedPreliminary reportBoeing E75 · Dresden, OHOn May 29, 2026, about 1153 eastern daylight time, a Boeing E75, N181RF, was substantially damaged when it was involved in an accident near Dresden, Ohio. The pilot and passenger were seriously injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA199Accident · No injuriesClass 3 · LimitedPreliminary reportCessna A188B · Blair, NEOn May 27, 2026, about 1130 central daylight time, a Cessna A188B airplane, N84497, sustained substantial damage when it was involved in an accident near Blair, Nebraska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA216Accident · No injuriesClass 3 · LimitedPreliminary reportCessna A188B · Doerun, GAOn May 23, 2026, about 1500 eastern daylight time, a Cessna A188B, N8288G, was substantially damaged when it was involved in an accident near Doerun, Georgia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB ERA26LA215Accident · Minor injuriesClass 3 · LimitedPreliminary reportTextron 172S · Jupiter Farms, FLOn May 22, 2026, about 1518 eastern daylight time, a Textron Aviation 172S, N294PL, was substantially damaged when it was involved in an accident near Jupiter Farms, Florida. The flight instructor and student pilot were not injured. The airplane was operated…NTSB CEN26LA202Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-32R-300 · Comanche, TXOn May 22, 2026, about 1840 central daylight time, a Piper PA-32R-300 airplane, N4556Q, was substantially damaged during an accident near Comanche, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA26WA211Accident · No injuriesClass 5 · ForeignNew Glasair Glasair Super II · Aquidauana, BrazilNTSB CEN26LA221Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S-2R · Gause, TXThe loss of engine power due to fuel starvation. Contributing to the accident was the separated wing fuel tank screen and sealant debris in the fuel tank.NTSB GAA26WA191Accident · No injuriesClass 5 · ForeignCessna 188 · De Los TsáChilas, EcuadorNTSB GAA26WA192Accident · No injuriesClass 5 · ForeignSonex Sonex · Lincolnshire, United KingdomNTSB WPR26LA183Accident · No injuriesClass 3 · LimitedPreliminary reportStinson 108-3 · Quilcene, WAOn May 12, 2026, at about 1049 Pacific daylight time, a Stinson 108-3 airplane, N588C, was substantially damaged when it was involved in an accident near Quilcene, Washington. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA201Accident · No injuriesClass 4 · LimitedFinal reportSky Ranger SKY Ranger 1 · Front Royal, VAThe pilot’s inadequate preflight inspection, which resulted in him taking off with the fuel selector in the OFF position, and the subsequent total loss of engine power due to fuel starvation.NTSB DCA26LA196Accident · No injuriesClass 4 · LimitedInvestigation openSkydweller S L Solar Impulse SI2 · Gulf of America (Gulf of Mexico)NTSB ERA26LA198Accident · Minor injuriesClass 3 · LimitedPreliminary reportNorth American Navion · New Salem, MAOn May 1, 2026, about 1910 eastern daylight time, a North American Navion, N8618H, was substantially damaged when it was involved in an accident near New Salem, Massachusetts. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26LA196Accident · No injuriesClass 3 · LimitedPreliminary reportBeech C23 · Bangor, MEOn May 01, 2026, at 1604 eastern daylight time, a Beechcraft C23 airplane, N18516, was substantially damaged when it was involved in an accident near Bangor, Maine. The private pilot and flight instructor were uninjured. The airplane was operated as a Title…NTSB CEN26LA173Accident · Minor injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Chanute, KSOn April 23, 2026, at about 1445 central daylight time, a Cirrus SR22T was substantially damaged when it was involved in an accident near Chanute, Kansas. The pilot and pilot-rated passenger sustained minor injuries. The airplane was operated as a Title 14…NTSB GAA26WA169Accident · No injuriesClass 5 · ForeignCessna 207 · Trinidad-Beni, BoliviaNTSB ERA26LA180Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Indiantown, FLOn April 18, 2026, about 2115 eastern daylight time, a Piper PA-28-181, N643FT, was substantially damaged when it was involved in an accident near Indiantown, Florida. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA173Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Salinas, CAThe flight instructor’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA163Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA30 · Auburn, WAOn April 18, 2026, about 1330 Pacific daylight time, a Piper PA-30 Twin Comanche, N741TJ, was substantially damaged when it was involved in an accident near Auburn, Washington. The pilot and pilot-rated passenger sustained minor injuries. The airplane was…NTSB GAA26WA167Accident · No injuriesClass 5 · ForeignSocata TB9 · Zborowo, PolandNTSB WPR26LA162Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · La Cienega, NMOn April 17, 2026, at about 0954 mountain standard time, a Cirrus Design Corp SR22, N654MC, sustained substantial damage when it was involved in an accident near La Cienega, New Mexico. The pilot receiving instruction and the flight instructor were not…NTSB ANC26LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna U206F · Juneau, AKA total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean.NTSB ERA26LA176Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Levittown, PRAn oil line separation at a barbed fitting in an experimental airplane, which resulted in a total loss of engine power due to oil starvation.