NTSB investigations, 1983, IL
3 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 2 |
| 1993 | 3 |
| 1995 | 1 |
| 1997 | 2 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 5 |
| 2003 | 4 |
| 2005 | 3 |
| 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\") = 1983
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\" = 310)
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") = 1983 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" = 310) 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 CHI83LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paris, ILThe plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned…NTSB CHI83IA269Incident · No injuriesIncident investigationFinal reportBoeing B-747 · Chicago, ILThe united airlines B747 was standing in the run up area adjacent to the runway. A flying tigers B747 was passing to his left. The crew of the parked B747 opened their overhead escape hatch and indicated to the taxiing B747 with a thumbs up sign that there…NTSB CHI83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chicago, ILThe acft collided with a parked acft on the ramp. The student pilot started the acft on a snow covered icy ramp at nightthe parking brakes were set but when the engine started the acft taxied into another acft. After the accident the brakesof the acft were…