NTSB investigations, 1984
16 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
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\" = 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") = 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" = 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 MKC85LA015Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Aurora, MOThe acft was landed gear up. The student plt put the gear down on downwind and then on a pre-landing check on final apchthe student retracted the gear. The CFI said the warning horn never sounded and she did not notice that the gear was up.NTSB FTW85LA007Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Amarillo, TXDuring the lndg roll, all 3 lndg gear collapsed. The plt stated that on short final he inadvertantly retracted the gear instead of the flaps. He immediately cycled it back down butthe gear collapsed shortly after touchdown.NTSB FTW85LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Crowell, TXThe plt stated that he lowered the landing gear on short final and that he received 3 green lights. During the landing roll a total gear collapse was experienced. A pilot witness on the ground stated that the nose gear did not appear to beextended when the…NTSB CHI85LA011Accident · No injuriesLimited investigationFinal reportMooney M20A · Tecumseh, MIUpon touchdown the landing gear collapsed. Inspection revealed the landing gear actuator handle was cracked aprx 1/2 inch above the actuator torque tube. The crack was through 3/4 of the circumference and there was a 10 deg bend in the tube near the crack.…NTSB DEN84LA296Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Carrington, NDAccording to the plt, the landing gear were extended on base leg but he did not recall seeing the green light indicating a down and locked configuration. As the acft touched down some resistance was felt by the plt as all 3 gear collapsed and the acft settled…NTSB NYC84LA266Accident · No injuriesLimited investigationFinal reportBeech B55 · Trenton, NJDuring landing roll, as the acft slowed to about 40 mph and the plt was transitioning to taxi mode, the landing gear collapsed. No mechanical fault or failure was reported. Witnesses observed the gear to be down during the approach.NTSB CHI84LA305Accident · No injuriesLimited investigationFinal reportBeech B-35 · Harrison, MIThe plt inadvertently landed the acft with the landing gear retracted. He said he forgot to lower the gear. Most of his 200+ hours of flight time had been in fixed gear acft.NTSB LAX84LA345Accident · No injuriesLimited investigationFinal reportBeech 35 · Concord, CAThe plt stated he landed in a x-wind & wanted to raise the flaps but raised the gear instead.NTSB SEA84LA126Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Las Vegas, NVThe plt stated he lowered the gear before entering the traffic pattern & noted a down-&-locked indication. He reported that during the landing flare, the gear unsafe horn sounded & he applied power to go around. However, he felt the acft scrap the surface, so…NTSB ATL84LA152Accident · No injuriesLimited investigationFinal reportBeech E55 · Charleston, SCAfter the landing the acft landing gear retracted during a period of maximum braking to avoid an arresting cable. During the examination of the landing gear door damage it was determined that the landing gear was retracted during the landing roll.NTSB ATL84LA142Accident · No injuriesLimited investigationFinal reportAero Commander 560F · Hilton, SCThe acft was landed with the gear retracted. The nose gear light indicating down remained'on' at all itmes but had no bearing on the landing gear extension/retraction system. The plt did not report using a checklist or lowering the landing gear. The landing…NTSB MIA84LA130Accident · No injuriesLimited investigationFinal reportBeech N-35 · Daytona Beach, FLThe acft landing gear collapsed during landing. The plt said he did a 'gump' checklist prior to landing and believed he was in a landing configuration. He also stated that he did'not know weather or not he raised the gear during the landingflare'.NTSB DEN84LA097Accident · No injuriesLimited investigationFinal reportSwearingen SA26AT · Ruidoso, NMThe acft landed with the gear retracted. The plt reported that 'due to moderate low level turbulence, the landing gear handle did not reach the full down position.' He stated that his passenger was sick due to turbulence.NTSB MKC84LA082Accident · No injuriesLimited investigationFinal reportMooney MK20B · Pocahontas, ARThe acft landing gear retracted during landing. The plt reported that the manually activated gear handle popped out of the gear down position during the landing roll. The plt indicated that he thought the gear handle was positively in the down lock position.NTSB NYC84LA079Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Philadelphia, PAThe plt broke out of the overcast at 1000 ft lowered flaps and landed the acft with the gear retracted. The plt said he had lowered the gear. The gear warning horn reportedly did not sound.NTSB CHI84LA075Accident · No injuriesLimited investigationFinal reportPiper J-4E · White Bear Lake, MNThe ski-equipped acft suffered landing gear failure during a landing on a snow covered turf rwy. The landing gear separated when an attach point failed. The plt gave fatigue failure as a reason for the failure.