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

6 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, 2001, 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\") = 2001
    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 FTW01LA212Accident · No injuriesLimited investigationFinal reportBeech 70 · College Station, TXthe loss of right engine power during takeoff initial climb for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Sep 30, 2001 · N45BD · Substantial damageNTSB FTW01IA183Incident · No injuriesIncident investigationFinal reportBoeing 737-347 · DFW Airport, TXThe local controller clearing the taxiing aircraft to cross the runway in front of the aircraft on takeoff roll. Contributing factors were the local controller's failure to follow FAA procedures and directives to visually scan the runway prior to issuing the…Aug 16, 2001 · N308WA · 2 aircraft · Minor damageNTSB FTW01LA179Accident · 1 fatalLimited investigationFinal reportPdps PZL-Bielsko SZD-55-1 · Uvalde, TXthe pilot's failure to maintain aircraft control during the base turn, which resulted in an inadvertant stall/spin.Aug 12, 2001 · N55VW · DestroyedNTSB FTW01LA108Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXthe pilot's failure to maintain directional control during the takeoff initial climb. Contributory factors were the pilot's lack of experience with the aircraft and the soft terrain.Apr 29, 2001 · N121CC · Substantial damageNTSB FTW01LA086Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXthe pilot's failure to maintain rotor rpm, which resuted in the main rotor contacting the tail during landing.Mar 25, 2001 · N121CC · Substantial damageNTSB FTW01LA055Accident · No injuriesLimited investigationFinal reportSchmidt Questair Venture · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll. Factors were the crosswind and soft terrain condition.Jan 30, 2001 · N425V · Substantial damage