NTSB investigations, CA
12 cases where the first occurrence was “Gear not extended”.
Cases per year
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 3 |
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\" = 'CA' 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" = 'CA' 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 LAX93LA340Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cameron Park, CAThe pilot's failure to assure that the landing gear was down and locked. Factors relating to this accident were the alternator failure due to a broken wire and the low battery output.NTSB LAX93LA174Accident · No injuriesLimited investigationFinal reportCessna T310R · Groveland, CAFailure of the pilot to follow the airplane's checklist which resulted in an inadvertent gear up landing.NTSB LAX93LA116Accident · No injuriesLimited investigationFinal reportCessna 210 · Fullerton, CAThe pilot's failure to follow the checklist. A factor relating to this accident was the misadjustment of the landing gear locking mechanism which caused intermittent operation.NTSB LAX91LA277Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Visalia, CAThe instructor/pilot-in-command's failure to adequately supervise the flight and the second pilot's improper use of the checklist and failure to maintain crew coordination to ensure that the landing gear was extended. Contributing to the accident was the…NTSB LAX90IA305Incident · Minor injuriesIncident investigationFinal reportBoeing 747-422 · Los Angeles, CAThe failure of the manufacturer to ensure that the landing gear selector valves and their associated drum link assemblies were properly installed prior to delivery of the aircraft. A factor in the accident was the lack of information available to the crew…NTSB LAX90IA293Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Los Angeles, CAImproper maintenance service by a company employee who allowed a foreign object (flashlight) to remain in the landing gear extend/retract linkage during a night servicing before the flight.NTSB LAX89LA187Accident · No injuriesLimited investigationFinal reportCessna T210N · Monterey, CAThe pilots improper use of the checklist when his attention was diverted.NTSB LAX89LA183Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Montague, CAThe pilot's failure to extend the landing gear because of inattention. Contributing to the accident was inadequate maintenance of the airplane which failed to repair the landing gear warning throttle position switch.NTSB LAX88LA318Accident · No injuriesLimited investigationFinal reportCessna T310R · La Verne, CAThe pilot stated that he was troubleshooting a problem with the airplane's fuel flow system. During the preflight run-up, he noticed that the fuel flow gauge for the right engine was reading too high. He took off to see if he could make an inflight…NTSB LAX88LA208Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Corona, CACompany maintenance personnel had replaced the nose landing gear assy and had conducted retraction tests prior to releasing the acft for flt. After takeoff the lndg gear was retracted and the flt was conducted without incident until, upon entering the traffic…NTSB LAX87LA262Accident · No injuriesLimited investigationFinal reportPiper PA-31T2 · Novato, CAAt the end of a cross country flt, the plt reported that he had extended the landing gear aprx 5 miles from the arpt and lowered partial flaps. Aprx 2 miles from the arpt the plt made shallow s turns for spacing and extended the rest of the flaps. The plt…NTSB LAX85LA381Accident · No injuriesLimited investigationFinal reportCessna 402A · San Jose, CAThe aircraft landed gear up. The pilot reported no malfunction and said he forget to lower the landing gear.