NTSB investigations: NONE, 2003, CA

6 cases on aircraft whose registry engine model is NONE. 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

19642026
NTSB investigations: NONE, 2003, CA per year, 1964–2026: 297 cases
19644
19653
19665
19678
19685
19698
19709
19717
19729
197312
197410
19756
19765
19777
19784
19795
19805
19814
19825
198312
19846
19855
19867
19872
19889
19894
199014
19918
19928
19933
19945
19955
19966
19975
19981
19993
20002
20011
20025
20036
20041
20056
20063
20076
20084
20096
20102
20114
20123
20133
20142
20152
20163
20171
20181
20192
20202
20212
20221
20265

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 year(c.\"eventDate\") = 2003
    AND 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'))
  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 LAX03LA291Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Lone Pine, CAthe pilot's inadequate assembly of the glider and improper preflight inspection, which resulted in an inadvertent deployment of the spoilers. Also causal was the pilot's failure to maintain obstacle clearance. His diverted attention to the control problems…Sep 19, 2003 · N71DA · Substantial damageNTSB LAX03CA277Accident · Minor injuriesData collectionFinal reportPZL PW-5 · Yreka, CAthe pilot's inadequate in-flight planning/decision and failure to maintain airspeed resulted in an inadvertent stall. A factor in the accident was the downdraft.Aug 30, 2003 · N105PS · Substantial damageNTSB LAX03CA201Accident · Minor injuriesData collectionFinal reportSchleicher ASW-20 · Idyllwild, CAThe combined effects of a loss of thermal lift and a gust induced loss of airspeed at a low above ground altitude, which resulted in a descent to impact with trees. The pilot's failure to maintain an adequate terrain clearance margin while cruising in…Jun 15, 2003 · N34LB · Substantial damageNTSB LAX03LA133Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · San Diego, CAthe pilot's misjudgment of the landing flare and descent rate. A contributing factor was the pilot's misjudged speed and distance.Mar 16, 2003 · N1169S · Substantial damageNTSB LAX03LA114Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · San Diego, CAthe pilot's use of an inadequate climb attitude during takeoff resulting in the proper climb rate not being established.Mar 16, 2003 · N31AP · 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 damage