NTSB investigations, 1982
14 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\") = 1982
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") = 1982 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 FTW83LA064Accident · No injuriesLimited investigationFinal reportBeech E33 · Little Rock, ARDuring the landing roll, all three of the landing gear retracted as the pilot was applying brakes to turn off at the first exit. FAA inspectors found the landing gear handle in the down position with the circuit breaker popped. The flaps were also found in…NTSB LAX83LA039Accident · No injuriesLimited investigationFinal reportCessna 210 · El Monte, CAThe pilot experienced a problem directly after takeoff when he discovered the landing gear would not retract. After continually trying to lock the gear in place, he executed an emergency landing. Investigation revealed a malfunction in the hydraulic power…NTSB MIA83LA041Accident · No injuriesLimited investigationFinal reportBeech 35 · Titusville, FLThe pilot reported that before landing, he extended the landing gear and observed a safe down and locked indication. He stated that as he applied brakes at about 45 KTS, the gear warning horn sounded and the gear collapsed. Also, he positively stated that the…NTSB FTW83LA022Accident · No injuriesLimited investigationFinal reportBeech H35 · Abilene, TXThe pilot stated that he extended the gear about 10 to 15 miles out to hold down the speed and descend. Before landing, he noted that none of his lights were working and he was unable to communicate with Abilene radio. Reportedly, he assumed the gear was down…NTSB ATL83LA010Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Camden, SCAccording to the pilot, he received landing information from the UNICOM operator for runway 7. He was advised to keep the pattern tight to accommodate heavy traffic at the airport. While expediting to get off the runway after landing, he reached to retract…NTSB CHI83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Indianapolis, INThe landing gear retracted at 64 mph during the takeoff roll. The takeoff was aborted and the aircraft slid on its fuselage. The landing gear systems all operated normally when checked after the accident.NTSB ATL83LA007Accident · No injuriesLimited investigationFinal reportBeech S35 · Macon, GAAfter landing and coming to a stop on the runway, the pilot made a 180 degree turn to proceed to a taxiway and began cleaning up the cockpit. During the turn, the gear collapsed. The pilot stated that he inadvertently raised the gear handle instead of the…NTSB FTW82DA369Accident · No injuriesFinal reportBeech A36 · Shawnee, OKLanding gear collapsed during landing roll.NTSB LAX82DA302Accident · No injuriesFinal reportBeech 58TC · Oakland, CAN17841, landed with the landing gear retracted at metropolitan Oakland airport. The pilot claims that the landing gear was lowered prior to landing. Efforts to reach the pilot for further comments concerning this flight were unsuccessful.NTSB LAX82DA296Accident · No injuriesFinal reportAero Commander 500S · Sacramento, CAPax/plt in right seat inadvertently raised gear instead of flaps.NTSB ATL82DA235Accident · No injuriesFinal reportBeech 58 · Birmingham, ALThe pilot stated that after a normal touchdown and a landing roll of 300-500 feet the gear retracted/collapsed. Subsequently, the entire landing gear system was ground checked and normal function of the system was found. The aircraft flaps were found in the…NTSB CHI82DA250Accident · No injuriesFinal reportPiper PA-30-160 · Salem, ILPilot stated he had 3 green gear lights. During touchdown and roll the landing gear collapsed. The landing gear control switch collar was defective and if the pilot did not hold the gear selector in the down position it may have returned to off before the…NTSB LAX82FVW03Accident · Minor injuriesFinal reportPiper PA-28R-200 · Las Vegas, NVThe pilot reported that during the night landing, he maintained a little more than normal speed and power since this was his first night landing at the mccarran airport. He stated that on final approach for landing, heavy left rudder was needed. He stated he…NTSB MIA82DA099Accident · No injuriesFinal reportBeech F33A · Ft. Lauderdale, FLDuring the landing roll, the landing gear retracted. The pilot recommended that the gear retract lever be located higher on the panel and not near the flap or cowl flap switch.