NTSB investigations, 2002, OK
5 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 7 |
| 1989 | 3 |
| 1990 | 4 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 3 |
| 2002 | 5 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
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\") = 2002
AND c.\"eventStateOrRegion\" = 'OK' 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" = 'OK' 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 FTW03FA053Accident · 1 fatalField investigationFinal reportCessna 172N · Lindsay, OKThe in-flight separation of the right wing due to the missing nut that secures the right wing's strut to fuselage fitting to the fuselage.NTSB FTW03FA028Accident · 1 fatalField investigationFinal reportHughes 269A · Fort Gibson, OKThe in-flight separation of the tail boom resulting from the failure of the fuselage to tail boom attachment fitting lugs, due to fatigue.NTSB FTW02LA205Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Purcell, OKThe in-flight cabin fire as result of non-compliance with an AD and a Service Bulletin. A contributing factor to the accident was night conditions.NTSB FTW02LA190Accident · No injuriesLimited investigationFinal reportBeech BE-300 · Tulsa, OKThe pilot's inadequate preflight of the airplane resulting in the in-flight separation of the left engine inboard access door.NTSB FTW02IA097Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Tulsa, OKThe failure of the horizontal stabilizer control system for undetermined reasons.