NTSB investigations, 1985, IL
10 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 11 |
| 1984 | 12 |
| 1985 | 10 |
| 1986 | 5 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 10 |
| 1990 | 9 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 10 |
| 1994 | 10 |
| 1995 | 5 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 2 |
| 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\" = 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") = 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" = 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 CHI86FA006Accident · No injuriesField investigationFinal reportCessna P210N · Grayslake, ILDuring descent the engine stopped running. The aircraft was landed in a soft field & nosed over. Only 4 gallons of fuel was found in the left fuel system with no evidence of leakage. The pilot only used the left system during the 2 hour flight. Fuel tanks…NTSB CHI85LA337Accident · No injuriesLimited investigationFinal reportCessna 402B · Moline, ILThe acft was landed on soft terrain 1500 ft short of the rwy following a total loss of pwr. The plt reported he failed to use fuel from the aux tanks during the flt and he exhausted the fuel in the main tanks. The fuel boost pumps are located in the main…NTSB CHI85LA329Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe student plt originally planned a x-country flt from janesville, WI, to champaign, IL, to galesburg, IL & back to janesville. The total route of flt was aprx 390 mi. The plt had calculated that he needed 3-3/4 hrs of fuel. At champaign, he purchased an…NTSB CHI85LA309Accident · No injuriesLimited investigationFinal reportCessna 150D · Lincoln, ILWhen the plt added pwr on final apch, the eng did not respond. An emergency landing was made in a rough fld. The relative humidity was aprx 60%. No mechanical failures/malfunctions were discovered during an eng examination.NTSB CHI85LA294Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILThe acft contacted a ditch during a forced landing following a loss of pwr shortly after takeoff. The plt reported that at an alt of aprx 200 ft AGL, during the takeoff climb, a total loss of pwr occurred. A left turn was made in an attemptto avoid buildings…NTSB CHI85LA201Accident · No injuriesLimited investigationFinal reportCessna 150 · Durand, ILWhile on a night flight the acft experienced a complete loss of engine power. An emergency landing was made to a road. During the landing the right wing of the acft strucka street sign & power pole. The plt stated to the authorities that the acft had…NTSB CHI85FEE01Accident · Minor injuriesFinal reportPiper PA-28-161 · Schaumburg, ILThe student plt & instructor (CFI) were practicing touch-&-go landings. The CFI reported that after about 1 hr of flt, the eng lost power after a touch-&-go as the acft was climbing thru about 200 to 300 ft AGL. A town & some bldgs were ahead, so the CFI made…NTSB CHI85LA141Accident · No injuriesLimited investigationFinal reportCessna T210L · Sauk Village, ILDuring a night preflight the fuel quantity was visually checked and the plt estimated each tank contained 35 gals. The left fuel guage indicated 220 pounds and the right guage was inop. After aprx 1 hour 50 minutes of flt time a total loss of power occurred.…NTSB CHI85LA127Accident · No injuriesLimited investigationFinal reportCessna 152 II · Wayne City, ILWhile en route on a night x-country flt the acft experienced fuel exhaustion. An emergency lndg was attempted to a road. The acft struck a power pole that was not visible in the darkness and then hung up in the wires. The acft was destroyed when it was…NTSB CHI85FA096Accident · No injuriesField investigationFinal reportCessna 150L · Wheeling, ILAt about 400 ft AGL during takeoff, the eng lost all power. The plt was able to regain partial power for aprx 20 sec, by 'milking' the throttle, then the eng stopped again. To avoid power lines & factories ahead, the plt turned back & landed on arpt property.…