NTSB investigations, IA
13 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2004 | 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\" = 352)
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" = 352) 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 CHI04FA234Accident · 2 fatalField investigationFinal reportCessna 172E · Decorah, IAThe pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…NTSB CHI01LA303Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sheldon, IAthe in-flight planning/decision and proper touchdown point not attained by the pilot. Contributing factors were the ingested exhaust valve and lack of experience of the pilot.NTSB CHI96FA146Accident · 3 fatalField investigationFinal reportCessna 421 · Bernard, IAthe pilot's operation of the airplane with known deficiencies, subsequent loss of oil from the left engine, and the pilot's failure to maintain minimum controllable airspeed (VMC), while diverting to an alternate airport. Factors relating to the accident…NTSB CHI93LA325Accident · No injuriesLimited investigationFinal reportCessna 152-II · Keokuk, IAthe loss of engine power due to an exhaust valve failure. A factor related to the accident is the power line.NTSB MKC89LA072Accident · No injuriesLimited investigationFinal reportCessna 310 · Cedar Rapids, IAThe proper touchdown point was not attained by the pilot and the crankshaft failure on one engine. Contributing to the accident were the weather conditions and the approach lights which were contacted.NTSB MKC88DCD02Accident · Serious injuriesFinal reportPrairie Flyers Tierra II · Prairie City, IAThe pilot was attempting to land in a hayfield and decided to abort the landing due to rough condition of field. As he pushed the throttle forward, the engine faltered and the plane touched down. The aborted landing was continued due to speed and…NTSB MKC88LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Cherokee, IAThe plt stated, that shortly after takeoff, the engine lost substantial pwr. Afterwards there was smoke in the cockpit. The PIC reversed his course with the intent to land on the departure arpt. When he felt he had the ldg field made, he attempted to lower…NTSB MKC87LA119Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Keokuk, IAThe PIC rptd a loss of manifold press during cruise flt and an inability to maintain alt. A forced lndg was made to the Keokuk arpt, but the PIC stated he was too high and fast for a lndg. The PIC made a go-around, but again approached too fast. Another…NTSB MKC85LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Norwalk, IAApproaching des moines airport the plt rptd to approach control of eng problems and wanted to know what airport was close for an precautionary landing. An attempt was made to land at an airstrip 3 mi east of his present posn. Unable to land at the airstrip…NTSB MKC85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Algona, IAAt about 100 ft AGL after takeoff, eng lost pwr. Plt attempted to circle to land on closest runway but eng was developing insufficient pwr to maintain altitude in turn. Acft touched down 150 ft short of threshold. Plt did not level wings prior to touchdown.…NTSB MKC84FA234Accident · 2 fatalField investigationFinal reportSims - Basset Varieze · Clarinda, IAWitnesses observed a ground run of aprx 2000 ft before lift-off was achieved after which the acft appeared to climb laboriously to about 100 ft AGL. Acft then executed steep, descending rt turn of about 240 degrees back toward the arpt. Acft collided with pwr…NTSB MKC83LA211Accident · No injuriesLimited investigationFinal reportMooney M20C · Bloomfield, IAWhile en route, the plt encountered a progressive, partial power loss. At 1st the eng began running rough, then the manifold pressure dropped to 15 inches (18 inches had been set for cruise). He heard a clicking noise & started a descent from his cruise alt…NTSB MKC82DA158Accident · No injuriesFinal reportFairchild Hiller FH 1100 · Mason City, IADuring a swath run, the engine RPM dropped to flight idle and the helicopter was landed hard in a clear area beside the field. An investigation revealed that a sensing line for the fuel control system had failed. This prevented the engine from operating above…