NTSB investigations, 2002, IL
3 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 12 |
| 1984 | 8 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 8 |
| 1988 | 10 |
| 1989 | 5 |
| 1990 | 2 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 8 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 6 |
| 2000 | 3 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 6 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 5 |
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\") = 2002
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\" = 130)
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") = 2002 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" = 130) 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 CHI03IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-131 · Chicago, ILThe maintenance facililty improperly assembled and installed the nose landing gear shock absorber assembly. Factors were the improper assembly which allowed the nose gear to turn 90 degrees to the direction of travel.NTSB CHI03FA025Accident · No injuriesField investigationFinal reportRobinson R22 · St. Jacob, ILFatigue fracture of the clutch assembly fan shaft and the resulting complete loss of power to the rotor drive system. A contributing factor was the loss of tail rotor authority due to the secondary failure of the control tube assembly.NTSB CHI02LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Harvard, ILThe pilot's failure to verify the extension of the landing gear. Factors were the alternator failure, and the main landing gear down locks not engaged.