NTSB investigations, 1998, IL
5 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 18 |
|---|---|
| 1983 | 14 |
| 1984 | 9 |
| 1985 | 9 |
| 1986 | 9 |
| 1987 | 8 |
| 1988 | 10 |
| 1989 | 3 |
| 1990 | 8 |
| 1991 | 7 |
| 1992 | 7 |
| 1993 | 4 |
| 1994 | 6 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 2 |
| 1998 | 5 |
| 1999 | 6 |
| 2000 | 6 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 4 |
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\") = 1998
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\" = 260)
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") = 1998 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" = 260) 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 CHI99LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · East St. Louis, ILThe student pilot's failure to maintain directional control.NTSB CHI99LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Cahokia, ILthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the quartering tailwind and the ditch that the airplane contacted.NTSB CHI98LA318Accident · Minor injuriesLimited investigationFinal reportWhetzel Thorpe T-18 · Rantoul, ILthe pilot not maintaining directional control. Factors were crops and encounter with unsuitable terrain.NTSB CHI98LA221Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILthe pilot's inadequate compensation for the wind conditions which resulted in a lack of directional control of the aircraft. Factors to the accident were the two airport signs and the crosswind.NTSB CHI98LA215Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grays Lake, ILthe pilot's not performing a recovery from a bounced landing and his not maintaining directional control. A factor was soft terrain.