NTSB investigations, 1985
10 cases where the first occurrence was “Complete gear collapsed”.
Cases per year
| 1982 | 14 |
|---|---|
| 1983 | 18 |
| 1984 | 16 |
| 1985 | 10 |
| 1986 | 2 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 2 |
| 1993 | 5 |
| 1994 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
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\" = 194)
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" = 194) 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 MIA86LA046Accident · No injuriesLimited investigationFinal reportBeech C-18S · Deland, FLThe pilot in the right seat was making his first landing in that make and model of aircraft. During the landing roll he tried to raise the wing flaps lever. Instead, he raised the landing gear lever causing the landing gear to retract.NTSB MKC86LA024Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Grandview, MOThis pilot was making a takeoff for a local flight in his Piper PA-24. He stated that he was airborne when he raised the landing gear switch but the airplane settled back to the runway. Pilot said he became airborne again but could not get a safe indication.…NTSB MIA85LA257Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Leesburg, FLThe pilot stated he was taxiing on a smooth asphalt taxiway in preparation for takeoff when the landing gear collapsed. A post- accident examination of landing gear failed to reveal any malfunction or failure that would have precluded normal operation of the…NTSB NYC85LA236Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Danbury, CTThe plt stated that on touchdown the left main gear collapsed followed by the right main gear and nose gear. The acft slid aprx 600 to 700 ft before stopping. According to the plt he confirmed the gear was down and locked while on base. A gear cycle test…NTSB BFO85LA076Accident · No injuriesLimited investigationFinal reportCessna 401 · Cheswold, DEAfter landing on runway 27, the pilot slowed the aircraft to approximately 30 mph. The aircraft had rolled out about 1000 feet when the gear horn sounded and all three landing gear collapsed. The pilot reached for the gear switch, which was in the up…NTSB LAX85LA347Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hollister, CAThe plt and gnd witnesses reported that during the takeoff roll, the nose gear collapsed, followed by the main landing gears. Post-accident investigation disclosed the landing gear control handle was in the down position. All of the landing gear…NTSB FTW85LA231Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Austin, TXThe plt stated he felt the gear extend and the corresponding decrease in airspeed when the gear was lowered during the apch. He stated he thought he observed a green gear down indication and he did observe the shadow of the extended gear on the ground as the…NTSB ATL85LA161Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Savannah, GAThe plt ldg the acft with the ldg gear retracted. He stated that he evidently forgot to extend the gear.NTSB MKC85LA097Accident · No injuriesLimited investigationFinal reportBeech 35 · Ames, IAThe plt reports that the acft had slowed to taxi speed after landing when the gear warning horn began to blow followed shortly by collapse of the landing gear. Examination of the landing gear electrical circuitry failed to reveal any deficiencies.NTSB MKC85FA076Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Hot Springs, ARThe first officer was making the landing and the acft bounced during touchdown. The captain's right hand, which had beennear the floor to the right of his seat, bumped the landing gear selector to the up position as the captain reached for the yoke. The…