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

8 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

19652026
NTSB investigations: Amateur-built UNKNOWN ENG, 2002, TX per year, 1965–2026: 155 cases
19651
19662
19681
19691
19713
19752
19764
19781
19801
19815
19821
19831
19843
19852
19862
19871
19883
19901
19921
19931
19941
19952
19963
19972
19992
20003
20016
20028
20034
20045
20057
20061
20077
20087
20093
20105
20113
20126
20136
20144
20153
20162
20174
20181
20194
20205
20211
20234
20245
20253
20261

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\" = 'TX' 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 FTW03LA058Accident · No injuriesLimited investigationFinal reportRamsay Lancair IV-P · Bulverde, TXThe pilot's misjudgment of speed and distance.Nov 21, 2002 · N222MR · Substantial damageNTSB FTW03LA015Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Edinburg, TXThe loss of tailrotor effectiveness due to the right quartering tailwind, which resulted in a hard landing. Factors were the lack of suitable surrounding terrain for landing, which included numerous surrounding obstacles, and the tailwind.Oct 17, 2002 · N303CH · Substantial damageNTSB FTW02LA230Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Aledo, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the performance of aerobatic maneuvers with low altitude.Aug 6, 2002 · N5C · DestroyedNTSB FTW02LA187Accident · 1 fatalLimited investigationFinal reportLidster Wittman Tailwind W-8 · Mesquite, TXThe in-flight separation of the outboard portion of the left wing due to the failure of the wing spar resulting from the builder's improper installation of a wing that did not meet the drawing specifications.Jun 23, 2002 · N14VK · DestroyedNTSB FTW02LA167Accident · No injuriesLimited investigationFinal reportAero Commander 500-S · La Porte, TXThe failure of a hydraulic line, which resulted in the loss of the brakes.May 25, 2002 · N98TT · Substantial damageNTSB FTW02LA150Accident · Serious injuriesLimited investigationFinal reportAubrey Challenger II · Lubbock, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 12, 2002 · N2NX · Substantial damageNTSB FTW02FA087Accident · 2 fatalField investigationFinal reportBeech A36 · Austin, TXThe pilot's failure to maintain airspeed, resulting in a stall. Contributing factors were the low ceiling, fog, and the unforecast weather conditions..Mar 1, 2002 · N7236L · DestroyedNTSB FTW02LA069Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Plainview, TXthe pilot's failure to maintain the proper glidepath, which resulted in landing short of the runway.Jan 16, 2002 · N7388V · Substantial damage