NTSB investigations, 2006
13 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 12 |
| 1984 | 12 |
| 1985 | 17 |
| 1986 | 11 |
| 1987 | 7 |
| 1988 | 4 |
| 1989 | 11 |
| 1990 | 6 |
| 1991 | 9 |
| 1992 | 7 |
| 1993 | 4 |
| 1994 | 18 |
| 1995 | 11 |
| 1996 | 6 |
| 1997 | 11 |
| 1998 | 9 |
| 1999 | 21 |
| 2000 | 9 |
| 2001 | 14 |
| 2002 | 18 |
| 2003 | 11 |
| 2004 | 6 |
| 2005 | 12 |
| 2006 | 13 |
| 2007 | 18 |
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\" = 190)
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" = 190) 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 SEA07LA036Accident · No injuriesLimited investigationFinal reportPiper PA 23-235 · Phoenix, AZThe landing gear collapsed for undetermined reasons while the aircraft was standing on the taxiway with the engines operating.NTSB SEA07LA026Accident · No injuriesLimited investigationFinal reportCessna 310B · Lake Stevens, WAThe collapse of the main landing gear for an undetermined reason while taxiing from landing.NTSB DFW06CA201Accident · No injuriesData collectionFinal reportCessna T210N · San Angelo, TXThe failure of the landing gear to extend as result of a frayed electrical wire.NTSB NYC06CA199Accident · No injuriesData collectionFinal reportStampe SV-4C · Taneytown, MDThe collapse of the right main landing gear for an undetermined reason.NTSB DCA06FA058Accident · No injuriesField investigationFinal reportBoeing MD-10-10F · Memphis, TNthe failure of the left main landing gear due to fatigue cracking in the air filler valve hole on the aft side of the landing gear. The fatigue cracking occurred due to the presence of stray nickel plating in the air filler valve hole. Contributing to this…NTSB NYC06CA152Accident · No injuriesData collectionFinal reportCessna 182F · Beverly, MACollapse of the nose landing gear for an undetermined reason.NTSB LAX06LA166Accident · No injuriesLimited investigationFinal reportMcKenzie Lancair IV-P Turbine · San Diego, CAThe collapse of the left main gear for undetermined reasons. A factor was the pilot's inadequate remedial action in response to the left main gear not locked warning light by not attempting to manually extend the gear to ensure it was fully down and locked.NTSB LAX06CA167Accident · No injuriesData collectionFinal reportCessna 310N · Lincoln, CAThe collapse of the nose gear due to an out of tolerance nose gear over center adjustment.NTSB ATL06LA052Accident · Minor injuriesLimited investigationFinal reportE Newton Newton RV-6A · Mooresville, NCThe collapse of the nose landing gear for undetermined reasons, which resulted in a nose over.NTSB CHI06LA089Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Sikeston, MOThe inadvertent landing gear retraction by the pilot during an after landing taxi.NTSB MIA06LA055Accident · No injuriesLimited investigationFinal reportBeech C90A · Tampa, FLThe collapse of the right main landing gear for an undetermined reason during the landing roll, which resulted in a collision with the runway. A factor contributing to the accident was the pilot's failure to follow the published emergency/abnormal procedures.NTSB LAX06LA101Accident · No injuriesLimited investigationFinal reportCessna R182 · Bullhead City, AZoverload of the nose landing gear actuator attach bracket resulting in collapse of the nose gear while taxiing. It is undetermined when and under what circumstances the overload occurred.NTSB MIA06LA048Accident · No injuriesLimited investigationFinal reportCessna 310N · Destin, FLThe down limit switch, which operates the landing gear mechanical stop, was bent in the up position and allowed the gear motor to continued to run, causing the gearbox to over-travel, pull on the landing gear rods, and retract the landing gear.