NTSB investigations: NONE, AZ

6 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight collision with terrain/water”. 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

19842026
NTSB investigations: NONE, AZ per year, 1984–2026: 6 cases
19841
19861
19951
19991
20021
20051

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\" = 'AZ' 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\" = 230))
  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 LAX05LA135Accident · 1 fatalLimited investigationFinal reportCameron Balloons A-210 · Marana, AZthe failure of the flying pilot to attain a proper climb rate and maintain an adequate clearance from rising terrain. Also causal was the commercial pilot's inadequate supervision of the flight and his delayed remedial action.Apr 13, 2005 · N210EW · Substantial damageNTSB LAX02LA111Accident · Serious injuriesLimited investigationFinal reportAvian Magnum IX · Sedona, AZThe pilot's decision to continue the landing approach after encountering a high wind condition. A factor in the accident was the pilot's decision to use the trees to try and slow the balloon's ground speed.Mar 16, 2002 · N2037U · Substantial damageNTSB LAX00LA033Accident · Serious injuriesLimited investigationFinal reportRaven RX-7 · Phoenix, AZThe pilot's delay in initiating a climb and his subsequent failure to attain and maintain clearance from mountainous terrain.Nov 13, 1999 · N4046M · Substantial damageNTSB LAX95LA285Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-B · Peoria, AZthe pilot's improper inflight decision to attempt a tail wind landing to a short runway.Aug 10, 1995 · N462E · Substantial damageNTSB LAX86LA316Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Marana, AZA Schweizer sgs 1-35, landed hard after a steep final approach. The pilot indicated that he was high on final approach and initially applied 30 degrees of flaps. He was still too high and elected to use 80 degrees (full) flaps. The aircraft landed hard nose…Aug 3, 1986 · N34180 · Substantial damageNTSB LAX84LA216Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 Astir CS · Marana, AZThe plt initially lined up for a straight-in approach to land, but on final approach, he decided to make a 360 deg turn to land in front of spectators who were along the beginning of the airstrip. As he was completing the turn to land, the left wing contacted…Mar 10, 1984 · N128SS · Substantial damage