NTSB investigations, 1995, IL
5 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\") = 1995
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") = 1995 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 CHI95LA281Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILinadequate preflight planning and preparation by the pilot and an inadverent stall encountered by the pilot.NTSB CHI95LA264Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Murphysboro, ILthe pilot's improper use of carburetor heat which led to a loss of power due to carburetor ice, and his failure to maintain airspeed during the forced landing. The carburetor icing conditions were a factor.NTSB CHI95FA212Accident · 1 fatalField investigationFinal reportTaylorcraft BC-65 · Plato Center, ILthe pilot not maintaining an adequate fuel supply, and not maintaining airspeed.NTSB CHI95FA161Accident · Serious injuriesField investigationFinal reportBeech A35 · Downers Grove, ILfuel contamination (water), and the pilot's inadequate aircraft preflight. A factor was trees.NTSB CHI95LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Rock Falls, ILthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's poor preflight planning/preparation.