NTSB investigations, IA
5 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 2 |
| 1989 | 1 |
| 1991 | 1 |
Where
Open the mapLatest cases
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\" = 354)
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" = 354) 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 CHI91LA155Accident · No injuriesLimited investigationFinal reportPiper J3 · Creston, IAIcing in the induction air control system.NTSB MKC89LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Leon, IABlockage of the engine air induction system by a field mouse nest. The nest was positioned so that it could not be seen during the pre-flight inspection. It became dislodged during the takeoff roll on the rough runway.NTSB MKC86LA171Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Iowa City, IAThe flight instructor stated that he had planned to conduct an engine-out drill after takeoff by reducing power to the starboard engine. During the engine-out drill the student reduced power to the operating engine and the aircraft landed hard back on the…NTSB MKC86LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lytton, IAThe acft was departing from a 2,500 ft long, grass, farm strip. The plt said he noticed after take off that the eng was not developing full power and he could not maintain alt. He attempted to land in an adjacent fld, but the ground was soft and the acft…NTSB MKC83LA075Accident · No injuriesLimited investigationFinal reportCessna 150F · Ollie, IAThe student reported that the eng lost aprx 500 RPM while he was practicing turns & stalls at an altitude of aprx 3500 ft MSL. Reportedly, the situation became worse & he was unable to maintain altitude. He applied carburetor heat, but it did not help.…