NTSB investigations, 1983
12 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\") = 1983
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") = 1983 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 ATL84LA011Accident · No injuriesLimited investigationFinal reportBeech 58 · Montgomery, ALDuring an apch to land, the plt lowered the gear handle, but observed that the nose gear light did not come on & the right main gear light was flickering. Consequently, he recycled the gear operation. After that, he reportedly saw all 3 indicating down &…NTSB LAX83LA440Accident · No injuriesLimited investigationFinal reportBeech A36 · Redding, CAReportedly, during the landing roll, the acft settled while the gear was in transit. At that time, the flaps were in the down position & were damaged. According to the plt, the gear lights were green. Later, he said that something may have gone wrong with the…NTSB MKC83LA183Accident · No injuriesLimited investigationFinal reportBeech M35 · Sioux City, IAThe plt stated that the landing gear switch was down when he started tha takeoff roll. When the acft had accelerated to aprx 50 mph during the takeoff roll, the landing gear retracted/collapsed, nose wheel first, followed by the main gear. The plt stated that…NTSB ATL83IA302Incident · No injuriesIncident investigationFinal reportMooney M20C · St.Simonsisland, GAAcft had neither a green light nor mechanical indication of safe gear confirmed by the tower. All landing gear collapsedon touchdown. The motor to actuator coupling which is common to both electric & manual landing gear systems failed.NTSB ATL83FA282Accident · No injuriesField investigationFinal reportPiper PA-34-22OT · Atlanta, GAThe acft was on a takeoff roll when the left main and nose gear retracted. Investigation revealed a flt switch for the hobbs meter had been installed to automatically record only flt time when the switch was in the flt position. In this postion the hobbs…NTSB MKC83IA152Incident · No injuriesIncident investigationFinal reportBeech E18S · Cedar Rapids, IAThe tailwheel failed to extend fully due to a lack of lubrication. The acft was landed normally and the tailwheel collapsed.NTSB ATL83FA189Accident · No injuriesField investigationFinal reportPiper PA-30 · Atlanta, GAAccording to the plt, he extended the gear, got a safe gear down indication & made an approach with the flaps retracted. The gear warning was not heard. The plt stated that after the acft rolled about 1500 ft after touchdown, and with all 3 gear on the…NTSB FTW83LA237Accident · No injuriesLimited investigationFinal reportBeech 58 · Georgetown, TXThe plt stated that during the landing, the initial touchdown on the main gear was normal. However, when the nose gear came in contact with the rwy, there was a brief hesitation, then the nose settled & the propellers struck the rwy. The plt applied back…NTSB MKC83LA080Accident · No injuriesLimited investigationFinal reportMooney M20F · Springfield, MOThe aircraft sustained damage when the left main and nose gears collapsed while the pilot was taxiing in from landing. The aircraft landed on runway 31 and had begun a right turn onto a taxiway when the nose gear and then the left main gear retracted. The…NTSB ANC83IA058Incident · No injuriesIncident investigationFinal reportPiper PA34-200T · Palmer, AKDuring touch go landing the student pilot placed the landinggear handle in the up polition while still on the ground, and immediately placed it in the down position. The gear collapsed. The instructor stated that the student appeared to be fatigued.NTSB ATL83LA098Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Charleston, SCThe plt stated that the landing gear collapsed after acft had rolled aprx 1200 ft during the landing. An exam of the acft revealed that the gear retraction transmission was torn out of its fuselage bulkhead mount, the landing gear push-pull cable rod ends…NTSB CHI83LA088Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · St. Jacob, ILThe pilot reported that during the landing roll, he inadvertently retracted the gear.