NTSB investigations: Amateur-built UNKNOWN ENG, 2002, AZ

7 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG. 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: Amateur-built UNKNOWN ENG, 2002, AZ per year, 1964–2026: 96 cases
19641
19671
19691
19721
19741
19791
19811
19871
19882
19892
19901
19912
19931
19941
19972
19981
19994
20002
20011
20027
20032
20045
20056
20062
20073
20082
20094
20103
20115
20121
20132
20142
20153
20161
20174
20192
20202
20212
20223
20233
20243
20262

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\") = 2002
    AND 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 ('99999'))
  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 LAX03LA011Accident · No injuriesLimited investigationFinal reportRotorway 162F · Tucson, AZthe failure of the secondary drive shaft.Oct 19, 2002 · N162AZ · DestroyedNTSB LAX02LA284Accident · No injuriesLimited investigationFinal reportSiemens Rotorway Exec 162 F · Overgaard, AZThe pilot's failure to check the wind direction prior to practicing autorotations, and his misjudged flare maneuver. The tailwind was a factor.Sep 13, 2002 · N104BJ · Substantial damageNTSB LAX02FA266Accident · Serious injuriesField investigationFinal reportAirbus Industrie A320-231 · Phoenix, AZThe captain's failure to maintain directional control and his inadvertent application of asymmetrical engine thrust while attempting to move the #1 thrust lever out of reverse. A factor in the accident was the crew's inadequate coordination and crew resource…Aug 29, 2002 · N635AW · Substantial damageNTSB LAX02LA230Accident · Serious injuriesLimited investigationFinal reportViolet Dragonfly · Tucson, AZThe pilot's loss of control resulting from his improperly planned approach and an inadvertent encounter with wake turbulence.Jul 18, 2002 · N48RV · DestroyedNTSB LAX02LA223Accident · 1 fatalLimited investigationFinal reportSteen SE-1 · Tucson, AZthe loss of engine power during takeoff for undetermined reasons.Jul 13, 2002 · N2018S · DestroyedNTSB LAX02LA206Accident · No injuriesLimited investigationFinal reportBeech BE76 · Prescott, AZThe student pilot's decision to abort the takeoff with insufficient runway remaining, resulting in a runway overrun and collision with a berm. A factor was the cabin door opening during the takeoff roll.Jun 13, 2002 · N6627U · Substantial damageNTSB LAX02LA121Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 165F · Chandler, AZThe tail rotor drive system failure as a result of incorrect installation procedures by the manufacturer's personnel.Apr 1, 2002 · N21901 · Substantial damage