NTSB investigations: NONE, 2003

5 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Loss of control - in flight”. 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, 2003 per year, 1982–2026: 120 cases
19824
19837
19845
19853
19869
19872
19886
19891
19906
19915
19927
19934
19948
19954
19966
19973
19983
19992
20007
20012
20023
20035
20043
20056
20063
20076

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.\"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\" = 250))
  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 DEN04LA006Accident · Serious injuriesLimited investigationFinal reportFirefly Balloons Galaxy 11B · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high-wind landing, resulting in a hard landing, the subsequent tipping of the balloon's basket, a post impact flash fire, and the ejection of two passengers. Contributing factors include the high wind…Oct 9, 2003 · N2190S · Substantial damageNTSB DEN04LA005Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons LBL · Albuquerque, NMthe inadequate in-flight planning/decision by the pilot. Contributing factors include the inadvertent activation of the deflation line by the pilot and the retaining wall.Oct 5, 2003 · N994AF · No 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 DEN03LA105Accident · Serious injuriesLimited investigationFinal reportAdams Balloon A55 · Albuquerque, NMthe pilot's improper planned approach for a landing and obstacle clearance not maintained. A contributing factor was the power lines.Jun 15, 2003 · N4031Z · DestroyedNTSB SEA03LA072Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Ephrata, WAThe pilot's failure to maintain aircraft control while on final approach for landing. Low airspeed was a factor.Apr 26, 2003 · N3839 · Substantial damage