NTSB investigations, 1986
11 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\") = 1986
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") = 1986 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 MKC87LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Olathe, KSDuring landing airplane ballooned due to wind gust. After touchdown. Airplane veered left and duirng pilot's correction, the left main landing gear leg broke off. Metallurgical evaluation revealed a previous fatigue failure in the fracture surface.NTSB MKC86FA197Accident · No injuriesField investigationFinal reportRockwell NA-265-80 · Liberal, KSThe right main landing gear downlock pin retracted just before or during touchdown. The airplane touched down 21 feet short of the runway. It traveled that 21 feet, traveled the full length of the 6999-foot runway, then traveled another one-fourth of a mile…NTSB MKC86LA176Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hope, ARThe CFI stated that the landing gear collpased during landing roll as he raised the flaps. The student, a commercial plt, was applying power for a touch and go at the time. Post accident examination of the landing gear system failed to disclose any…NTSB DEN86LA196Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Fargo, NDThe plt said that he activated the landing gear retraction switch during the landing roll. The gear retracted causing the acft to settle on the rwy.NTSB MIA86LA222Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Cleveland, MSThe pilot stated that when he took off, the acft was overweight and he was unable to remain airborne. He attempted a running landing, the skids dug in and collapsed causing the spray boom to swing forward and break the bubble canopy.NTSB MIA86LA170Accident · No injuriesLimited investigationFinal reportCessna 177RG · Jacksonville, FLThe plt stated that the landing gear indicator light showed the gear to be down & locked. When the acft touched down the landing gear collasped and the acft slid to a stop. Post crash examination of the landing gear showed it to operate normally in all modes.…NTSB MKC86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Olathe, KSDuring a takeoff roll fm johnson county executive airport, the PIC stated that the left landing gear collapsed and the aircraft impacted the rwy and veered off into soft terrain. Inspection revealed that when electrical power was initiated and the gear switch…NTSB MIA86LA116Accident · No injuriesLimited investigationFinal reportBeech BE-95 · Hollywood, FLThe acft had not been flown in over 2 yrs & the last annual inspection was performed 1-25-83. The acft had to be jump started due to a dead battery. During ldg roll-out, the gear collapsed. An exam of the bottom of the acft revealed damage consistent with the…NTSB MIA86LA114Accident · No injuriesLimited investigationFinal reportCessna 177RG · Orlando, FLThe plt stated that on final apch he extended the landing gear but on touchdown the gear completely collapsed. Post crash examination of the acft revealed that the alternator belt was loose allowing the battery to drain down enough so the electric hydraulic…NTSB MKC86LA060Accident · No injuriesLimited investigationFinal reportBeech N35 · Hot Springs, ARThe pilot stated that he was on the landing roll and reached for the flap switch and moved the landing gear switch instead. The landing gear then retracted.NTSB CHI86LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · St. Cloud, MNThe plt was diverting into galesburg due to bad weather at his original destination. Following an ILS approach at galesburg he spotted the rwy at '200 ft plus' off to his right. He then 'side-stepped' to the right but touched down in a crabbed angle. He…