NTSB investigations, FL
24 cases where the first occurrence was “Gear not extended”.
Cases per year
| 1985 | 6 |
|---|---|
| 1987 | 3 |
| 1988 | 7 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 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\" = 196)
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" = 196) 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 MIA95LA081Accident · No injuriesLimited investigationFinal reportCessna R182 · Orlando, FLthe failure of the pilot-in-command to insure the landing gear was extended before landing.NTSB MIA94LA187Accident · No injuriesLimited investigationFinal reportCessna 210-M · Orlando, FLThe improper installation of a nose gear actuator hydraulic line by an unknown person that bent it at installation. Contributing to the accident was the failure of the line allowing all hydraulic fluid to vent overboard disabling the normal and emergency gear…NTSB MIA93LA044Accident · No injuriesLimited investigationFinal reportBeech 1900D · Fort Myers, FLFailure of the pilot-in-command to follow the checklist and complacency of the pilot-in-command for failure to extend the landing gear before landing.NTSB MIA92IA100Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe total failure of the main landing gear uplock and sequencing valve for undetermined reasons.NTSB MIA91LA070Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Orlando, FLFailure of the pilot to follow proper procedures resulting in a gearup landing.NTSB MIA90IA128Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Tampa, FLThe failure of the pilot to follow procedures outlined in the checklist, resulting in the airplane landing with landing gear retracted.NTSB MIA89LA230Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · St Augustine, FLInadvertent retraction of the landing gear, and the instructor pilot's inadequate supervision of the flight.NTSB MIA89FA138Accident · No injuriesField investigationFinal reportSwearingen SA-226-AT · Jacksonville, FLThe failure of the pilot in command to use the airplane landing checklist and assure that the landing gear was down and locked prior to landing.NTSB MIA89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Fort Pierce, FLAir traffic controllers stated that while the aircraft was on short final they noticed that the gear on the aircraft was not extended. They attempted to contact the pilot but he never responded. The pilot stated that he failed to extend the landing gear prior…NTSB MIA89IA032Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Melbourne, FLThe plt stated that while doing touch and go landings at Melbourne, he put the gear handle down but did not check to confirm that it was down. He continued the approach and landed gear up. Afterward, the pilot noticed that the gear pump circuit breaker had…NTSB MIA88IA181Incident · No injuriesIncident investigationFinal reportCessna P210N · Daytona Beach, FLThe plt rprtd that while on final apch to land, he became distracted by conversation with the passenger & failed to lower the landing gear. Subsequently, the acft was landed with the gear retracted. After it was lifted from the rwy after the incident, the…NTSB MIA88LA158Accident · No injuriesLimited investigationFinal reportBeech E55 · Pahokee, FLWhile on an instructional flt practicing short & soft field landings, the acft was landed gear up. The instructor plt stated there was no failure or malfunction of the landing gear warning horn and that when the throttle was retarded fully the horn sounded.NTSB MIA88IA150Incident · No injuriesIncident investigationFinal reportBeech 58 · Jacksonville, FLThe plt stated that while on landing rollout, the gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed evidence that would suggest that the gear was up and locked at the time the acft landed.NTSB MIA88IA119Incident · No injuriesIncident investigationFinal reportCessna 210M · Orlando, FLWhile on a positioning flt the acft landed gear up. The plt stated that he failed to follow the checklist & forgot to lower the landing gear. Examination of the landing gear assy by FAA personnel revealed no failure or malfunction.NTSB MIA88LA100Accident · No injuriesLimited investigationFinal reportBeech V-35 · Fernandina Bch, FLWhile on a personal flt, the acft landed gear up. The plt stated that he lowered it. He also stated that the gear warning horn was inoperative. Operational check of the landing gear revealed no discrepancies except for an improperly adjusted warning horn &…NTSB MIA88IA068Incident · No injuriesIncident investigationFinal reportBeech 99 · Tampa, FLThe commuter air carrier crew received an unsafe nose gear indication on final approach. The approach was abandoned and all efforts to use the emergency extension procedures were to no avail. The crew secured both engines on final and landed nose gear up.…NTSB MIA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Quincy, FLThe plt stated that he performed a prelanding check on final apch but failed to lower the landing gear. He continued the apch, & just prior to touchdown, was advised that the gear was not down. The apch to landing was continued & the acft slid to a stop. He…NTSB MIA88LA022Accident · No injuriesLimited investigationFinal reportMooney M20F · Vero Beach, FLPlt stated that while turning final approach he believes he placed the landing gear handle in the down position and observed red gear intransit lights. He was occupied by a strong wind for the landing and never checked for a gear down and safe indication. The…NTSB MIA86IA029Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Miami, FLThe plt stated that he was on a practice instrument apch & after arriving at minimums, declared a missed apch, retracted his landing gear & flaps but decided to land and continued his apch & inadvertently landed gear up.NTSB MIA86IA017Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe plt stated that he made a normal apch to rwy 12 buy on landing rollout as the nose of the acft touched down the nose gear ass'y folded & the acft slid to a stop, post crash examination of the acft revealed that the green light for the nose gear remained…NTSB MIA86LA003Accident · No injuriesLimited investigationFinal reportCessna 414 · Sarasota, FLThe plt stated that his right main gear would not extend, so he circled the arpt for about 1/2 hour to burn off excess fuel, retracted the remaining gear & intentionally landed gear up on rwy 32. Examination of the right main landing it to extend beyond it's…NTSB MIA85LA258Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ormond Beach, FLThe plt stated that he forgot to extend the landing gear prior to touchdown while on a test flight after maintainence work was performed on the acft.NTSB MIA85IA182Incident · No injuriesIncident investigationFinal reportPiper Aztec PA-23-250 · Vero Beach, FLWhile in the traffic pattern, the cfi's attention was diverted as he attempted to assist ATC with some radio frequency info. While being so distracted, he permitted the student to land the acft with the gear up.NTSB MIA85IA156Incident · No injuriesIncident investigationFinal reportRockwell AC-500 · Palm Beach, FLOn final apch, the acft was advised twice by the tower to go around because his landing gear was not extended, the acft did not respond & landed gear up on rwy 13. Examination of the landing gear system after the occurrence revealed the warning horn was…