NTSB investigations, IA
58 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
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.\"eventStateOrRegion\" = 'IA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353)
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."eventStateOrRegion" = 'IA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353) 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 MKC83LA014Accident · No injuriesLimited investigationFinal reportBeech C23 · Des Moines, IAThe pilot executed a forced landing after the engine stopped. The pilot successfully landed the aircraft on a highway, the left wing struck a pole and the aircraft came to rest in a ditch.NTSB MKC82DA163Accident · No injuriesFinal reportCessna 140 · Eldora, IAThe oil pressure dropped to zero & the plt shut down the engine, & the acft landed in a bean field. All of the oil had blown out of the oil filler opening via a loose fitting oil filter cap. The plt stated he had changed the oil prior to flt.NTSB MKC82DA159Accident · No injuriesFinal reportBell 47G-2 · Palo, IAThe pilot reported that during flight at about 300 ft AGL, the engine sputtered and lost power. He entered an autorotation, turned into the wind, and landed in a bean field. As the aircraft descended into the beans, the spray boom became entangled in the…NTSB MKC82DA148Accident · No injuriesFinal reportCessna T188C · Near Traer, IAThe pilot failed to refuel during the last loading, and shortly after returning to the spray area, the engine quit. A forced landing was made in an alfala field during which the aircraft collided with a fence. During the investigation, no fuel was found in…NTSB MKC82DA133Accident · No injuriesFinal reportBeech E-35 · Calamus, IAWhile demonstrating the use of the acft's fuel system during eng runup, the plt mistakingly left the fuel selector on the fuselage aux tank which contained only a small amount of fuel. When the eng quit after lift-off, the plt moved the selector to the left…NTSB MKC82DA100Accident · No injuriesFinal reportCessna 182B · Milford, IAThe pilot reported that he was low on fuel and was flying over the airstrip before landing to drop a banner that he was towing. Shortly after the banner was released, the aircraft encountered turbulence causing the aircraft to go into a steep bank. At about…NTSB MKC82DA067Accident · No injuriesFinal reportCessna 150 · Nevada, IAAfter returning from a cross-country flight, the pilot made one go-around when he thought he was too fast. Just beyond the end of the runway at about 200 ft AGL, the engine stopped running due to fuel exhaustion. The pilot attempted to turn and land on the…NTSB MKC82DA033Accident · No injuriesFinal reportPiper PA-28-151 · Des Moines, IAThe aircraft had not been refueled after a previous flight of about one hour. The pilot visually checked the fuel and estimated 41 gallons remaining. He believed that he had about 5.2 hours of fuel. During an IFR flight, he diverted for an enroute fuel stop…