NTSB investigations, 1983
18 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\") = 1983
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") = 1983 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 ATL84LA037Accident · No injuriesLimited investigationFinal reportBeech BE-58P · Beaufort, SCThe plt stated that he started having problems with various eletrically operated components during the latter part of the flt. During descent into Beaufort, he lost the ability to transmit and communicated to ATC by transponder. The plt said he put the gear…NTSB ATL84LA030Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Montgomery, ALAccording to the plt he had an unsafe gear indication while in the traffic pattern. He alerted the tower to the problem and made a low pass over the runway. He was informed by tower personnel that the gear looked down and normal. During the landing the plt…NTSB LAX83LVM11Accident · No injuriesFinal reportBeech 55 · Watsonville, CAThe acft was landed with the gear retracted. The plt stated that he lowered the gear but raised it when the tower requested that he circle while equipment was cleared from the rwy. When he was cleared to land he approached the rwy andas he did so saw a person…NTSB DEN83LA219Accident · No injuriesLimited investigationFinal reportCessna 320B · Mandan, NDThe acft landed gear up after the normal and emergency extension systems failed to extend the landing gear. During the appraoch to land the plt noticed the landing gear down light'would not come on'. A missed approach was executed. The pltdiscussed the…NTSB DEN83LA223Accident · No injuriesLimited investigationFinal reportMooney M-2O · Rock Spring, WYThe acft landed with the landing gear up after the flt experienced some delays in landing because an airshow was in progress. The accident plt was told to hold 30 minutes and then 6 minutes later was told he could land if he hurried and'got back to the arpt…NTSB FTW83LA385Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Catarina, TXThe acft was damaged when the landing gear was retracted during landing rollout at Catarina, TX. The plt identifed himself as larry day from chattanooga, TN. He claimed to have had engine trouble and was unable to extend the gear for landing. Post accident…NTSB LAX83IA342Incident · No injuriesIncident investigationFinal reportBeech B-35 · Fullerton, CAThe gear collapsed on the landing roll. Gear were found to be dry. Tge pilot had a gear flag but does not remember a green light.NTSB ATL83LA251Accident · No injuriesLimited investigationFinal reportCessna 310 · West Point, VAThe plt stated that he was practicing single engine procedures and landings. On his fourth landing to a full stop he landed gear up. He said he just forgot to put the gear down.NTSB LAX83LA321Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Franklin, CAThe acft landed wheels-up during a training flt. The CFI was simulating a single-engine landing. The CFI said he and thestudent were engrossed in conversation and forgot to lower the landing gear prior to landing. The warning horn did not sound until just…NTSB DEN83LA220Accident · No injuriesLimited investigationFinal reportBeech D35 · St. Thomas, NDThe plt stated that after a flt to inspect farm fields he 'made an approach to the arpt and landed with the gear up.' He said he heard the gear warning as he crossed the threshold but interpeted it as a stall warning.NTSB NYC83LA149Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Glens Falls, NYThe acft landed with the wheels up on a dual instructional flight. The flight had been doing air work before returning to glen Falls to continue training with takeoffs and landings. During the 1st landing the acft came over the threshold a little low but it…NTSB MKC83LA119Accident · No injuriesLimited investigationFinal reportBeech J35 · Fulton, MOThe pilot stated that before landing he was having electrical problems and shortly after touchdown all three landing gear collapsed. The persons who removed and inspected the acft have stated that the damage to the landing gear doors consisted of…NTSB MKC83LA095Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Springfield, MOThe student pilot retracted the landing gear during landing roll. This was to be a touch and go landing and the student had just raised the flaps in preparation for takeoff. The instructor stated that during the landing roll the student pilot moved the gear…NTSB CHI83LA182Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Champaign, ILThe acft was landed with the gear up. Investigation revealed during a retraction test, that no malfunction of the landing gear system prevented normal operation. Electrical system showed that the warning the horn did not operate. When the cockpit was checked…NTSB FTW83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Oklahoma City, OKWitnesses reported that the landing gear was lowered at the outer marker on an ILS approach. The pilot stated that he extended full flaps at about 400 feet AGL just as they broke out of the clouds. Almost immediately after landing the pilot retracted the…NTSB ATL83LA102Accident · No injuriesLimited investigationFinal reportMooney M20J · Marietta, GAThe acft landed with the wheels up during an attempted go-around. The plt who was receiving instruction decided as the acft floated during a landing that he would go-around. Full power was added as someone retracted the landing gear and the flaps. The acft…NTSB CHI83LA093Accident · No injuriesLimited investigationFinal reportBeech D18S · Plymouth, INPilot landed the aircraft with the landing gear up. He said he put the gear selector down but after landing the lever was up. He also mistook gear up warning horn for a stall warning. No malfunctions were reported.NTSB ATL83LA090Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Greenville, SCThe aircraft landing gear collapsed during landing rollout. The pilot stated that he raised the gear instead of the flaps during the landing roll.