NTSB investigations, 1985, IL
6 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 6 |
| 1984 | 1 |
| 1985 | 6 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 7 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 3 |
| 1995 | 4 |
| 1997 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 2 |
Where
Latest 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 year(c.\"eventDate\") = 1985
AND c.\"eventStateOrRegion\" = 'IL' 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\" = 351)
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 year(c."eventDate") = 1985 AND c."eventStateOrRegion" = 'IL' 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" = 351) 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 CHI86FA111Accident · No injuriesField investigationFinal reportPiper PA-46-310P · Evanston, ILThe aircraft was on climbout on an IFR flight plan in VMC conditions when the engine failed. A restart was attempted and the engine ran for a minute or less. Subsequent attempts were unsuccessful. The aircraft was over lake Michigan and had insufficient…NTSB CHI85FEV04Accident · No injuriesFinal reportHiller UH-12D · Breese, ILThe plt reported that the eng began losing power while he was en route at an alt of aprx 200 ft AGL. He turned & initiated an autorotation to a road construction site. The helicopter landed tail low. Subsequently, the tail boom was chopped off & the…NTSB CHI85FA370Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Romeoville, ILThe pilot was reportly departing on a xcountry flt. During climbout, in the traffic pattern, upon reaching base leg area the acft was observed to turn back towards the arpt descend and strike the ground. Witnesses reported no sound of engine was heard. The…NTSB CHI85LA364Accident · No injuriesLimited investigationFinal reportThornhill Replica TS-1 · Marengo, ILThis aircraft is powered by a rotary engine. Thrust is varied by shorting out one magneto and varying the firing order of the cylinders via an electrical cam arrangement. The mixture control is limited to only a few settings. One of which is level flight.…NTSB CHI85FEV02Accident · Serious injuriesFinal reportde Havilland DH-82A · Elmore, ILWhile on a x-country flt, the eng lost power & the prop continued to windmill. Subsequently, the acft crashed during an emerg landing. During the crash landing, the plt's shoulder harness failed at the upper attachment point & he received head & back…NTSB CHI85LA103Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Peoria, ILThe acft was damaged in an off arpt forced lndg after the rear eng quit at about 350 ft AGL. The plt stated that he could not feather the prop on the rear eng which had stopped. Since the acft would not climb the plt elected to land off the arpt. The post acc…