NTSB investigations, 2003, WI
3 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 6 |
| 2002 | 11 |
| 2003 | 3 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 3 |
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\") = 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\" = 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") = 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" = 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 CHI03LA281Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fennimore, WIThe loss of engine power in cruise flight due to carburetor icing. A factor was the unsuitable terrain the pilot encountered during his forced landing.NTSB CHI03LA256Accident · No injuriesLimited investigationFinal reportNicoson Antares MA-33 · Palmyra, WIThe loss of engine power for undetermined reasons and the pilot misjudging the descent rate during the forced landing, which resulted in the airplane landing short of the desired landing area. A factor to the accident was the fence.NTSB CHI03LA125Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wilmot, WIThe loss of engine power for an undetermined reason, and the unsuitable terrain encountered for the forced landing. A factor was the fence.