NTSB investigations, 2003, WI
2 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
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\") = 2003
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") = 2003 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 CHI03LA255Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Lakewood, WIA loss of engine power due to fuel starvation as a result of the pilot's improper use of the fuel system. A related factor was the tree.NTSB CHI03FA138Accident · 4 fatalField investigationFinal reportPiper PA-31P · Woodruff, WIThe pilot's failure to follow the before take-off checklist which led to an improper selection of the auxilliary fuel tanks for the takeoff leading to the subsequent fuel starvation of the left engine. Additional causes were the pilot not maintaining minimum…