NTSB investigations, 1982
8 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
Latest 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\" = 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") = 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" = 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 LAX82DA342Accident · No injuriesFinal reportBeech F33A · San Jose, CAThe pilot stated that while making a right turn onto a taxiway after a landing rollout, the nose gear and right main landing gear collapsed. The investigation revealed that the pilot was accustomed to flying a different model Beech aircraft in which the flap…NTSB FTW82DA373Accident · No injuriesFinal reportCessna 310R · Tomball, TXThe right main landing gear collapsed on landing roll. The aircraft departed the runway and crossed a drainage ditch sustaining substantial damage to the fuselage. Inspection of the landing gear revealed the bolt that connects the retraction drag link, pn…NTSB ATL82DA250Accident · No injuriesFinal reportCessna 310C · Brunswick, GAThe pilot experienced an electrical failure inflight after takeoff. He hand-cranked the landing gear to the down and locked position prior to landing. After rolling approximately 200 feet, he left main gear collapsed. Examination of the landing gear revealed…NTSB NYC82DA111Accident · No injuriesFinal reportPiper PA-24-250 · Bridgeville, PAThe pilot landed the aircraft wheels up. The pilot stated the sun was in his eyes which prevented him from seeing the gear lights. He also stated the warning horn did not sound. Examination revealed no abnormalities in the gear system operation.NTSB FTW82DA232Accident · No injuriesFinal reportBeech 58 · Oak Grove, LAThe pilot reported that during his landing roll, he intended to retract the flaps, but inadvertently rectracted the landing gear instead.NTSB CHI82DA166Accident · No injuriesFinal reportCessna 210 · Galesburg, ILThe pilot was discussing short field landing techniques and the use of flaps with the student pilot/passenger and forgot to lower the landing gear. The wheels up landing resulted in substantial damage to the aircraft.NTSB FTW82DA151Accident · No injuriesFinal reportPiper PA-23-250T · Lake Dallas, TXThe pilot stated the landing gear indicated down and locked and the touchdown was normal. During the landing roll the gear retracted. During the slide down the runway the left engine caught on fire causing substantial damage to the aircraft. Examination by a…NTSB MIA82DA083Accident · No injuriesFinal reportPiper PA-30 · Placida, FLThe pilot stated that during the beginning of the landing roll the right main and nose landing gears collapsed. Examination revealed that the retraction torque tube arm fitting, Piper p/n 21012-03, which links the right main and nose gear to the retraction…