NTSB investigations, CA
11 cases where the first occurrence was “Complete gear collapsed”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1993 | 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\" = '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\" = 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" = '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" = 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 LAX93LA291Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Thermal, CAthe pilot's inadvertent movement of the landing gear selector switch to the up position. A factor in the accident was the difference in cockpit switch layout between the PA23 and PA39 aircraft.NTSB LAX91LA284Accident · No injuriesLimited investigationFinal reportBeech E-55 · Bakersfield, CAThe pilot's improper use of the landing gear retraction by selecting gear up instead of flaps up during the landing roll-out. Contributing to the accident was the lack of familiarity with the airplane.NTSB LAX88LA084Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Blythe, CAA Cessna T210L was found abandoned with the landing gear collapsed. Skid marks were noted on the ground where the aircraft had touched down on the rough terrain. The pilot was never identified and traces of illegal contraband were found in the aircraft.NTSB LAX85LA347Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hollister, CAThe plt and gnd witnesses reported that during the takeoff roll, the nose gear collapsed, followed by the main landing gears. Post-accident investigation disclosed the landing gear control handle was in the down position. All of the landing gear…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 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 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 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 LAX83LA039Accident · No injuriesLimited investigationFinal reportCessna 210 · El Monte, CAThe pilot experienced a problem directly after takeoff when he discovered the landing gear would not retract. After continually trying to lock the gear in place, he executed an emergency landing. Investigation revealed a malfunction in the hydraulic power…NTSB LAX82DA302Accident · No injuriesFinal reportBeech 58TC · Oakland, CAN17841, landed with the landing gear retracted at metropolitan Oakland airport. The pilot claims that the landing gear was lowered prior to landing. Efforts to reach the pilot for further comments concerning this flight were unsuccessful.NTSB LAX82DA296Accident · No injuriesFinal reportAero Commander 500S · Sacramento, CAPax/plt in right seat inadvertently raised gear instead of flaps.