NTSB investigations, 1995, WI
4 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 4 |
| 1984 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 5 |
| 1990 | 4 |
| 1991 | 4 |
| 1992 | 5 |
| 1993 | 2 |
| 1995 | 4 |
| 1996 | 2 |
| 1998 | 2 |
| 2000 | 2 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 1 |
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\" = '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\" = 240)
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" = '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" = 240) 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 CHI96FA052Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Steuben, WIfailure of the pilot to select alternate air. Darkness and snowy weather conditions were related factors.NTSB CHI96LA039Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Stevens Point, WIflying into known icing conditions and descending below the minimum descent altitude.NTSB CHI96FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Fond Du Lac, WIthe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain altitude. Factors included the weather obscuration due to snow and fog, the dark night, and the pilot's lack of recent night flight time.NTSB CHI95IA204Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Green Bay, WIthe weather condition (turbulence in clouds). A factor was the flight crew's abrupt control of the airplane.