NTSB investigations, 2006
7 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\") = 2006
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") = 2006 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 CHI07CA028Accident · No injuriesData collectionFinal reportCessna 421C · Moline, ILThe incorrect installation of the torque link scissor assembly by maintenance personnel, which resulted in the collapse of the right main landing gear during landing.NTSB ATL07LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Alabaster, ALThe jammed landing gear hydraulic motor shuttle valve.NTSB CHI06CA279Accident · No injuriesData collectionFinal reportMeyers MAC-145 · Manistique, MIThe pilot not verifying the landing gear selector position prior to starting the taxi.NTSB MIA06LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Marathon, FLThe separation for undetermined reasons of the stud (P/N 6541204-5) which secures the main landing gear actuator assembly side brace to the main landing gear outer cylinder, allowing partial collapse of the right main landing gear while taxiing after landing.NTSB LAX06LA225Accident · No injuriesLimited investigationFinal reportCessna 210K · Novato, CAThe failure of the left main landing gear to extend for undetermined reasons.NTSB SEA06CA087Accident · No injuriesData collectionFinal reportCessna 310R · Billings, MTCollapse of the right main landing gear during the landing roll for an undetermined reason.NTSB CHI06CA068Accident · No injuriesData collectionFinal reportCessna 310Q · Griffith, INThe overload failure of the right main landing gear locking mechanism due to undetermined reasons.