NTSB investigations, 1997
10 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1982 | 22 |
|---|---|
| 1983 | 16 |
| 1984 | 16 |
| 1985 | 15 |
| 1986 | 9 |
| 1987 | 14 |
| 1988 | 10 |
| 1989 | 9 |
| 1990 | 10 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 16 |
| 1994 | 5 |
| 1995 | 6 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 6 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 6 |
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\") = 1997
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\" = 192)
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") = 1997 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" = 192) 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 MIA98IA001Incident · No injuriesIncident investigationFinal reportGrumman G-73 · Fort Lauderdale, FLthe partial failure of a component of the hydraulic system resulting in the collapse of the nose landing gear during the landing roll.NTSB ANC97LA150Accident · No injuriesLimited investigationFinal reportCessna 402C · Kivalina, AKAn overstress fracture of the nose landing gear attachment. A factor associated with the accident was the rough landing area.NTSB SEA97FA202Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · Seattle, WAfatigue failure of the nose landing gear upper lock link, due in part to reduced strength after the manufacturing process was changed from forged to machined plate stock; and inadequate non-destructive inspection process for testing the link.NTSB MIA97LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Orangeburg, SCFailure of the pilot to recover from the bounced landing. Contributing to the accident was the pilots complacency.NTSB IAD97LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Cambridge, MDThe student pilot's failure to properly recover from a bounced landing.NTSB IAD97LA077Accident · No injuriesLimited investigationFinal reportCessna 182P · Wentworth, NHPilot's inadequate preflight planning to determine the suitability of an unimproved field for landing.NTSB CHI97LA151Accident · No injuriesLimited investigationFinal reportBeech 35 · Liberty, MOretraction of the nose gear for undetermined reason(s).NTSB ATL97LA070Accident · Minor injuriesLimited investigationFinal reportEugene Clements Pulsar · Indianola, MSThe pilot's failure to correctly recover from a bounced landing leading to the collapse of the nose gear. Factors were the pilot's lack of recent flight time and lack of aircraft familiarity.NTSB MIA97LA154Accident · No injuriesLimited investigationFinal reportGrumman American G-1159 · Miami, FLThe failure of the Landing gear nose gear for undetermined reasons.NTSB ATL97LA038Accident · No injuriesLimited investigationFinal reportBeech 23 · Palatka, FLfailure of the nose gear for undetermined reason(s).