NTSB investigations, 2000, IL
4 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
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\" = 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") = 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" = 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 CHI01LA030Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Worth, ILThe pilot's inadequate preflight of the airplane and his failure to verify the fuel supply on board, which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the lack of suitable…NTSB CHI01LA019Accident · No injuriesLimited investigationFinal reportZenair CH2000 · Springfield, ILthe loose carburetor heat control clamp bolt and carburetor heat not available to the pilot. Factors were the low altitude, the carburetor icing conditions, the fence and the security gate.NTSB CHI00LA176Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Joliet, ILthe failure of the pilot to obtain fuel and the inadequate preflight planning and preparation by the pilot. Factors to the accident were the fuel exhaustion and the ravine at the end of the runway.NTSB CHI00LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Bethalto, ILthe improper in-flight decision of the pilot to fly past the Vandalia airport onto Saint Louis Regional and the fuel exhaustion. A factor was the ditch.