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

19822026
NTSB investigations: NONE, CA per year, 1982–2026: 10 cases
19821
19832
19882
19912
19961
20072

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.

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.Oct 15, 2007 · N17888 · Substantial damageNTSB 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.Mar 11, 2007 · N273W · Substantial damageNTSB 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.Oct 20, 1996 · N65844 · Substantial damageNTSB LAX91LA408Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fremont, CAThe pilot failed to adequately compensate for the prevailing wind conditions.Sep 26, 1991 · N4113G · Substantial damageNTSB 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.Aug 4, 1991 · N53AS · Substantial damageNTSB 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…Jun 3, 1988 · N7768S · Substantial damageNTSB LAX88LA145Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAMar 27, 1988 · N2655H · Substantial damageNTSB 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.'Nov 27, 1983 · N62BG · Substantial damageNTSB 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…Jul 24, 1983 · N53619 · Substantial damageNTSB 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…Jul 11, 1982 · N90639 · Substantial damage