NTSB investigations, 2000, IL
7 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 7 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 6 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 6 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 4 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 7 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 6 |
| 2007 | 6 |
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 year(c.\"eventDate\") = 2000
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\" = 350)
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") = 2000 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" = 350) 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 CHI01LA023Accident · No injuriesLimited investigationFinal reportErcoupe 415-E · Minier, ILthe carburetor ice and after takeoff, the unsuitable terrain the pilot encountered during the forced landing. Factors were the carburetor icing conditions and the plowed field condition.NTSB CHI00LA298Accident · No injuriesLimited investigationFinal reportMorrison E-RACER · Sugar Grove, ILthe owner/builder's inadequate modification to the engine air intake system and the inadvertent engine shutdown. Factors included the low air pressure of the air intake system and the excessive fuel flow to the manifold.NTSB CHI00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chapin, ILthe pilot's failure to refuel the aircraft prior to the flight and exhaustion of the fuel supply. A factor to the accident was the embankment.NTSB CHI00LA162Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Joliet, ILthe engine failure for undetermined reasons. Factors were the low altitude, remedial action not possible by the pilot, and the ditch.NTSB CHI00LA112Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Kankakee, ILthe misjudged glidepath by the pilot. Factors were the failure of the impeller seal resulting in a total loss of engine oil and subsequent engine failure, the plowed farm field, and the lack of suitable terrain for the forced landing.NTSB CHI00FA110Accident · Minor injuriesField investigationFinal reportHughes 369D · Lemont, ILthe loss of engine power for undetermined reasons. A factor was the operation within the cross "hatched area" of the helicopter's height/velocity curve by the company.NTSB CHI00LA067Accident · No injuriesLimited investigationFinal reportBeech V35 · Schaumburg, ILinadequate aircraft preflight by the pilot and fuel consumption calculations not being preformed by the pilot. Factors to the accident were fuel exhaustion, the rocks/boulders, and the high vegetation.