NTSB investigations, 1986, WI
4 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 4 |
| 1984 | 9 |
| 1985 | 9 |
| 1986 | 4 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 9 |
| 1990 | 7 |
| 1991 | 7 |
| 1992 | 3 |
| 1993 | 12 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 5 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2005 | 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\") = 1986
AND c.\"eventStateOrRegion\" = 'WI' 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 year(c."eventDate") = 1986 AND c."eventStateOrRegion" = 'WI' 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 CHI86LA214Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Menominee Falls, WIThe plt stated that the eng had quit 3 times in the past 2 weeks. The purpose of the flt was to insure that the eng was working properly. During takeoff, it lost power at about 100 ft AGL. The plt tried to turn & land on the sw part of the arpt. However, a…NTSB CHI86FA192Accident · No injuriesField investigationFinal reportCessna 177RG · Oshkosh, WIThe IFR flt experienced an engine failure during the landing apch to the destination aprt in Oshkosh, WI, and the plt ditched the acft in lake winnebago. Exam of the acft showed that the eng failed due to fuel exhaustion. The plt reported there were 60…NTSB CHI86FEP04Accident · No injuriesFinal reportDay Skybolt DB · Wisconsin Rapid, WIThe plt thought he had sufficient fuel for a 'short trip around the pattern.' However, shortly after taking off from rwy 29, the eng began to lose power. The plt attempted to land on rwy 2, but all power was lost & he was unable to reach the rwy. He landed…NTSB CHI86FEP03Accident · Minor injuriesFinal reportSteinorth Extra Long EZ · Kenosha, WIDuring an apch to land, the eng of the home built acft lost power. The plt tried to restart the eng by using the ignition switch, but was unable. He turned to land in a pasture, but the acft hit an electrical wire & came to rest in a row of trees. The plt…