NTSB investigations: NONE, CA

5 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Miscellaneous/other”. 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

19862026
NTSB investigations: NONE, CA per year, 1986–2026: 5 cases
19861
19891
19921
20031
20071

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\" = 430))
  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 LAX07CA172Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Los Alamitos, CAfailure of the towrope during the initial climb out.May 22, 2007 · N65844 · Substantial damageNTSB LAX03LA097Accident · 1 fatalLimited investigationFinal reportFirefly 11B · Yountville, CAA bystander was impaired by drugs and did not follow the pilot's directive to release the balloon as it began its ascent.Feb 25, 2003 · N1501H · No damageNTSB LAX92LA275Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Olancha, CA1) The tow pilot's intentional premature release of the glider, which had become airborne, when the tow plane failed to achieve sufficient airspeed during its takeoff ground roll, and, 2) the glider having insufficient altitude at the time of release to…Jul 3, 1992 · N173SS · Substantial damageNTSB LAX89LA291Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAInadequate crew coordination between the tow pilot and glider pilot, failure of the glider pilot to obtain proper assistance, and the tow pilot's misunderstanding of the glider pilot's intentions.Aug 30, 1989 · N65843 · 2 aircraft · DestroyedNTSB LAX86LA360Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 III B · California City, CAThe plt stated he was towed to an alt of aprx 2,000 ft AGL. After release the canopy came open and the plt returned to the arpt. On final apch he noticed the airspeed indicator was indicating 'low forties'. The plt stated the next thing he remembered was…Sep 5, 1986 · N630BG · Destroyed