NTSB investigations: NONE, CA
10 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Undershoot”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1988 | 2 |
| 1991 | 2 |
| 1996 | 1 |
| 2007 | 2 |
Where
Latest 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 390))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 390))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA08CA011Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Tehachapi, CAThe pilot's misjudged distance/altitude that led to an undershoot, and his failure to attain the proper touchdown point.NTSB LAX07CA104Accident · No injuriesData collectionFinal reportSchleicher ASW-27B · Williams, CAThe pilot's misjudged distance/altitude and delay in retracting the spoilers that led to an undershoot, which resulted in a collision with terrain.NTSB LAX97LA024Accident · No injuriesLimited investigationFinal reportSchweizer 2-33-A · Los Alamitos, CAThe student pilot's failure to properly handle the glider, and the instructor pilot's inadequate supervision.NTSB LAX91LA408Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fremont, CAThe pilot failed to adequately compensate for the prevailing wind conditions.NTSB LAX91LA349Accident · No injuriesLimited investigationFinal reportLet L-13 · Byron, CAThe on ground collision with a hidden ditch not visible to the pilot during the landing roll out phase of a forced landing.NTSB LAX88LA209Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Vacaville, CAAt the end of a pleasure flt, the plt extended the downwind leg for landing, thinking that the touchdown altitude was 12 ft instead of, in actuality, 220 ft. the plt normally flew out of another airport with an alt of 12 ft. from the extended downwind, the…NTSB LAX88LA145Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CANTSB LAX84LA076Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G-103 · California City, CAAccording to the plt, he was turning to final approach when the glider's left wing struck the ground. Reportedly, he had gotten 'too low & slow.'NTSB LAX83LA358Accident · No injuriesLimited investigationFinal reportLaister LK10 · Jacumba, CAThe acft struck a bush during a landing short of the rwy. The instructor in the rear seat noted that the airspeed indicator at that position did not register below 60 mph by design. The instructor had no recent experience in this makeof acft and had no…NTSB LAX82DA254Accident · No injuriesFinal reportBlanik L-13 · Murrieta, CAPilot landed short of runway in a glider and impacted the ground at high speed with high sink rate. He had released early from an aerotow and descended at high airspeed with dive brakes open which accelerated his rate of sink. He was not injured in the…