NTSB investigations, 1985
17 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\") = 1985
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") = 1985 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 ATL86LA043Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Spartanburg, SCDuring landing roll the landing gear collapsed and the acft skidded to a stop on the rwy. The acft was substantially damaged and the plt was not injured. A witness stated that he observed the landing gear in the down position while the acft was in the traffic…NTSB LAX85LA375Accident · No injuriesLimited investigationFinal reportCessna T210 · Bishop, CAThe plt reptd the landing gear collapsed during the landing roll and that the lnd gear down light was illuminated while on final approach. Examination of the aircraft disclosed the lnd gear doors were damaged by the side loads and that both main lnd gears…NTSB ANC85LA156Accident · No injuriesLimited investigationFinal reportCessna 210 · Northway, AKThe right main gear collapsed during landing. Post accident examination of the landing gear disclosed the rear door actuator rod failed and the gear door was bent. The right hand main gear downlock failed in an area which appeared to have been previously…NTSB MIA85LA236Accident · No injuriesLimited investigationFinal reportMooney M20F · Ft. Myers, FLThe acft settled to the rwy during the takeoff roll after the landing gear retracted. The plt stated that the landing gear collapsed for an unknown reason. A post accident inspection of the landing gear and related components revealed no defects or…NTSB MKC85LA155Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Salina, KSThe plt stated that he was receiving a multi-engine flight check from a designated flt examiner. They were still rolling after a landing when the examiner requested a go-around. The plt said that after advancing the throttles, he reached for the flap switch &…NTSB LAX85LA289Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lincoln, CADuring arrival at dusk, the plt attempted to lower the landing gear, but did not observe a gear dowm light indication. He recycled the gear several times, then utilized the emergency gear extention sys. He stated that when he used the extention sys, he…NTSB DEN85LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Kalispell, MTN904V, a privately owned B-35, skidded off to the side of a runway during landing. The plt said that he inadvertently activated the gear up switch instead of the flap switch. The right landing gear collapsed causing the plt to lose control of acft.NTSB NYC85LA135Accident · No injuriesLimited investigationFinal reportGulfstream 681 · Millville, NJThe plt reported that when the landing gear was lowered during the apch, the right main gear light did not illuminate, however, the 'in-transit' light went out. He also reported, the gear warning horn stopped sounding and the hydraulic pressure was normal.…NTSB LAX85LA249Accident · No injuriesLimited investigationFinal reportHiller 12-C · Casa Grande, AZThe plt was demonstrating autorotations to a touchdown on a dirt rwy into a 5 kt headwind. On the final landing he said that the touchdown felt the same as others he had done. Speed at touchdown was 15 mph and the helicopter slid forward in a straight line…NTSB ATL85LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Hilton Head, SCThe plt stated that the landing gear selector was placed in the down position while on downwind for ldg & upon touchdown the landing gear collapsed. Post crash examination of the landing gear failed to disclose any mechanical failure or malfunction of the…NTSB DEN85LA116Accident · No injuriesLimited investigationFinal reportBeech 58TC · Gallup, NMThe pilot stated that he inadvertently raised the landing gear during the landing roll.NTSB CHI85LA159Accident · No injuriesLimited investigationFinal reportCessna 310B · Shelbyville, INWhen the gear was extended during the apch, a down & locked indication was not obtained. The plt made several attempts to lock the gear down, using both the electrical & manual systems, but was unable. After touchdown, the right main gear collapsed. The acft…NTSB ATL85LA128Accident · No injuriesLimited investigationFinal reportVarieze Duncan/Varieze · Ocracoke, NCDuring landing, the tab which connects the landing gear cross tube failed allowing the right gear to collapse. The acft has an experimental certificate. The failure appeared to be due to design limitations.NTSB CHI85LA142Accident · No injuriesLimited investigationFinal reportCessna 172RG · Portland, INUpon landing the nose gear was down & locked, but both main gear collapsed. The plt was not certain if a down & locked indication was received before touchdown. During a gear retraction/extension test after the accident, the gear operated normally. Also, the…NTSB LAX85LA167Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Barbara, CADuring arrival at Santa Barbara, the plt was unable to extend the ldg gear. Efforts at gear extension using the emergency hand pump failed & the plt landed with the acft's gear partially extended. An exam of the acft revealed an electrical problem of…NTSB CHI85LA105Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILThe private plt & his instructor were practicing instrument approaches. The instructor stated that the fuel gages were reading low & the VOR needle was oscillating, so they decided to make a straight-in landing. He stated that they lowered the gear & flaps,…NTSB FTW85LA101Accident · No injuriesLimited investigationFinal reportSwearingen SA26-T · Dallas, TXThe landing gear retracted during the takeoff roll & the acft dropped to the rwy surface & slid to a stop. No obvious reason for the unwanted retraction was noted by FAA maintenance personnel who did a post accident exam of the acft. The gear selector handle…