NTSB investigations, 1984
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
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\") = 1984
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") = 1984 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 MKC85FA032Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Harrison, ARThe acft was being operated as skyways flt 488. The first officer was flying the acft. The acft touched down on the rwy aprx 1584 feet from the approach end and after a short roll, the landing gear warning horn sounded and the left wing settled to the ground.…NTSB MIA85LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Williston, FLThe left seat pilot stated that he was doing touch and go landings on runway 04. He continued to state that on the last landing he touched down on the runway, then added full power and retracted the flaps, but inadvertantly retracted the landing gear. The…NTSB LAX84LA430Accident · No injuriesLimited investigationFinal reportBeech A36 · Van Nuys, CAThe acft landed 'gear up' during practice takeoffs and landings. The plt stated that he 'forgot' to extend the landing gear prior to landing. The tower had given him instructions to 'make a short approach.' No mechanical problems were reported.NTSB SEA84LA189Accident · No injuriesLimited investigationFinal reportMooney M20E · Scappoose, ORPlt lowered gear in traffic pattern and gear down and locked green light was received. Plt failed to check the gear bar indicator. Acft touched down with gear extended 1/4 of the way. Inspection revealed landing gear motor bearingswere worn out.NTSB CHI84IA224Incident · Minor injuriesIncident investigationFinal reportBeech 99 · Chicago, ILLanding gear extended but not locked. Crew could not rectify situation by using normal and emergency gear extension procedures. Gear collapsed on touchdown. Investigation disclosed a fatigue crack in rt main gear hydraulic actuator allowing a loss of…NTSB MIA84IA177Incident · No injuriesIncident investigationFinal reportGrumman G-111 · West Palm Beach, FLAfter a repositioning flt, the main gear collapsed. An exam of the hand pump selector control valve revealed that one of the two dump ports for thr flap position had a hydraulic leak. Reportedly, this allowed system pressure to retract the gear. The valve,…NTSB MKC84LA137Accident · No injuriesLimited investigationFinal reportBeech BE95A55 · Springfield, MOThe acft landing gear collapsed during landing. The plt said he was following a metroliner & put the gear handle 'down' but does not remember the gear indicators. He reduced the throttles to about 11 inches of manifold pressure & does not remember hearing a…NTSB MIA84LA131Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Titusville, FLThe plt could not get the left main gear extended for landing and then could not get the right main and nose gear to retract for a'belly'landing. The acft was landed on the sod beside the rwy with the left main retracted. The nose gear collapsed during the…NTSB LAX84LA240Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Phoenix, AZThe gear was inadvertently retracted at about 50 mph by the pilot in command during landing roll.NTSB MIA84LA087Accident · No injuriesLimited investigationFinal reportBeech B-58 · Tallahassee, FLThe acft landed with the right main gear & nose gear stuck in the retracted position, with the left main gear stuck in the extended position. Investigation revealed that the landing gear actuating rod had failed.NTSB LAX84LA159Accident · No injuriesLimited investigationFinal reportBeech D55 · Monterey, CAAccording to the plt, he extended the gear & flaps before landing, & on final apch, he rechecked that the gear was down & the green gear down & locked light was illuminated. He & both passengers reported that the acft touched down on the wheels, then it…NTSB CHI84FA076Accident · No injuriesField investigationFinal reportBeech BE-99 · Galesburg, ILThe main gear retracted while the acft was being taxied to the taxioff position. Investigation revealed that a landing gear maintenance valve PN22400-1, SN19 manufactured by airright inc had corroded and was allowing stray voltage to cyclethe landing gear…