NTSB investigations, FL
11 cases where the first occurrence was “Complete gear collapsed”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1998 | 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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' 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 ATL99LA032Accident · No injuriesLimited investigationFinal reportCessna 310C · Ft Myers, FLThe inadequate preflight inspection of the airplane by the pilot and subsequent malfunction of the nose gear strut, and the pilot's failure to follow the landing checklist.NTSB MIA91IA117Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Ochopee, FLFailure of the student to use the checklist, inadequate supervision by the pic/cfi, and inadequate supervision by the FAA principle operations inspector.NTSB MIA90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Naples, FLCollapse of the landing gear during the landing roll due to an undetermined reason.NTSB MIA90IA005Incident · No injuriesIncident investigationFinal reportMooney M20F · Pensacola, FLImproper rigging of the landing gear which resulted in an overload failure.NTSB MIA88LA010Accident · Serious injuriesLimited investigationFinal reportBeech A-90 · Ft Lauderdale, FLAfter the plt placed the master switch on to start the engines the landing gear collapsed. He stated that the passenger, in the co-plt seat, bumped the landing gear handle into the up position. The passenger stated that he did not. Insp of the acft revealed…NTSB MIA86LA058Accident · No injuriesLimited investigationFinal reportMooney M20F · Gainesville, FLThe plt stated that when he extended his landing gear all seemed normal except he did not get a green light, he recycled the gear with the same result & then flew by the tower & they stated that the gear appeared to be down, but upon touchdown after a ground…NTSB MIA86LA046Accident · No injuriesLimited investigationFinal reportBeech C-18S · Deland, FLThe pilot in the right seat was making his first landing in that make and model of aircraft. During the landing roll he tried to raise the wing flaps lever. Instead, he raised the landing gear lever causing the landing gear to retract.NTSB MIA85LA257Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Leesburg, FLThe pilot stated he was taxiing on a smooth asphalt taxiway in preparation for takeoff when the landing gear collapsed. A post- accident examination of landing gear failed to reveal any malfunction or failure that would have precluded normal operation of the…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 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 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.