NTSB investigations, 1999
10 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 48 |
|---|---|
| 1983 | 27 |
| 1984 | 33 |
| 1985 | 23 |
| 1986 | 24 |
| 1987 | 20 |
| 1988 | 20 |
| 1989 | 33 |
| 1990 | 14 |
| 1991 | 13 |
| 1992 | 21 |
| 1993 | 21 |
| 1994 | 9 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 17 |
| 1998 | 9 |
| 1999 | 10 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 9 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 7 |
| 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\") = 1999
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\" = 191)
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") = 1999 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" = 191) 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 LAX00LA004Accident · No injuriesLimited investigationFinal reportCessna 421B · Montague, CAThe collapse of the left main landing gear during the landing rollout for undetermined reasons, which resulted in the pilot's loss of directional control.NTSB FTW00LA002Accident · No injuriesLimited investigationFinal reportCessna 210L · Fayetteville, ARThe cause of the right main gear collapse was undetermined. A factor was the failure of the gear 'down & locked' switch resulting in a false 'down & locked' indication in the cockpit.NTSB FTW99LA258Accident · No injuriesLimited investigationFinal reportCessna 172RG · Fort Smith, ARThe failure of the electric pump motor/hydraulic power pack resulting in the collapse of the right main landing gear upon landing.NTSB MIA99LA236Accident · Minor injuriesLimited investigationFinal reportMichael L. Luckey Sportsman 2 + 2 · Grand Junction, TNThe improper spoiler extension by the passenger following the bounced landing, which resulted in the hard landing and collapse of the left main landing gear.NTSB CHI99LA291Accident · No injuriesLimited investigationFinal reportCessna 182 · Tecumseh, MIfracture of the right main landing gear strut.NTSB CHI99LA265Accident · No injuriesLimited investigationFinal reportCessna 310N · Eden Prairie, MNmaintenance personnel installed washers which were not large enough in diameter to prevent the retraction/extension scissors links from separating from each other.NTSB FTW99LA169Accident · No injuriesLimited investigationFinal reportCessna 414 · Springdale, ARThe failure of the right main landing gear torque tube support bracket/pivot bearing which resulted in the failure of the landing gear locking mechanism.NTSB DEN99LA090Accident · No injuriesLimited investigationFinal reportBeech D95A · Englewood, COThe collapse of the right main landing gear during landing due to a fatigue crack, in the strut, which had an undetermined origin.NTSB LAX99LA097Accident · No injuriesLimited investigationFinal reportCessna 414 · Phoenix, AZThe overload failure of the left main gear locking mechanism due to improper system rigging by maintenance personnel.NTSB NYC99LA051Accident · No injuriesLimited investigationFinal reportCessna 650 · Columbus, OHThe collapse of the airplane's right main landing gear due to inadequate design by its manufacturer.