NTSB investigations: NONE, AZ

11 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Hard landing”. 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, AZ per year, 1982–2026: 11 cases
19821
19832
19841
19921
19931
19951
19961
20041
20061
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\" = '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\" = 200))
  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 LAX07CA071Accident · Serious injuriesData collectionFinal reportBalloon Works Firefly 9B-15 · Peoria, AZThe balloon’s inadvertent encounter with a downdraft, which resulted in a hard landing.Jan 17, 2007 · N9087Z · No damageNTSB LAX07CA036Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Tucson, AZThe pilot's improper use of the spoilers during the landing flare, which resulted in a hard landing, and his inadequate bounced landing recovery technique.Nov 15, 2006 · N4115M · Substantial damageNTSB LAX04CA310Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Maricopa, AZthe pilot's encounter with a dust devil during landing flare, which resulted in a hard touchdown.Sep 2, 2004 · N2873H · DestroyedNTSB LAX96FA344Accident · Serious injuriesField investigationFinal reportThunder and Colt Colt 240A · Phoenix, AZThe pilot's impairment of judgment and performance due to drugs which led to his misjudgment of his descent rate during landing. Contributing factors were: his failure to activate the deflation device (rip line) and turn off the pilot lights, improper use of…Sep 27, 1996 · N434TC · Minor damageNTSB LAX95LA172Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 180A · Tucson, AZthe inability of the pilot to compensate for the wind conditions which resulted in the basket tipping over following touchdown during a high-wind landing.Apr 27, 1995 · N738TC · No damageNTSB LAX93LA296Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 160A · Chandler, AZThe pilot's failure to adequately evaluate the weather conditions and subsequent uncontrolled touchdown resulting in a hard landing. Gusty wind conditions were a factor in the accident.Jan 30, 1993 · N128TC · No damageNTSB LAX93LA084Accident · Serious injuriesLimited investigationFinal reportRaven S-55A · Peoria, AZThe balloon's encounter with a gusty wind shear condition during the final descent for landing at an altitude insufficient for the pilot to take corrective action to prevent a hard landing.Dec 26, 1992 · N2815S · No damageNTSB LAX84LA246Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 6B · Prescott Valley, AZWhen the Balloon took off, the winds were virtually calm. However, during the last 30 minutes of flt, the surface winds increased to an estimated 15 KTS which necessitated a high wind landing. The gondola tipped over during the landing & one of the passengers…Apr 8, 1984 · N2014F · No damageNTSB LAX84LA063Accident · Serious injuriesLimited investigationFinal reportRider AA-4 · Salome, AZThe plt of the balloon was making a precautionary landing due to his proximity to the mexican border. To avoid high tension wires, the plt 'ripped out' at a higher than normal altitude resulting in a hard landing. The plt received a fractured skull when he…Nov 14, 1983 · N27676 · No damageNTSB LAX83LA170Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Mesa, AZAccording to the plt, there was no wind when he began the sight-seeing flt; however, after takeoff, the wind steadily increased to aprx 12 KTS. By this time, the balloon was approaching a large green field, so he elected to land rather than take a chance of…Mar 15, 1983 · N5714B · No damageNTSB LAX82DA098Accident · No injuriesFinal reportRaven S-55A · Glendale, AZThe balloon made a hard landing on rocky desert terrain and the occupants were thrown out. The balloon became airborne while unoccupied and the envelope collided with power lines. The wind was reported to be blowing at 5 to 8 KTS.Feb 6, 1982 · N5571N · Substantial damage