NTSB investigations: NONE, 1990

7 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight collision with object”. 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, 1990 per year, 1982–2026: 141 cases
19826
19838
19845
19857
19865
19873
19886
198911
19907
19916
19922
19937
19943
19951
19968
19976
19983
19993
20004
20018
20026
20034
20046
20056
20065
20075

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\") = 1990
    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\" = 220))
  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 LAX90DVA10Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Westley, CAThe pilot's failure maintain obstacle clearance.Aug 19, 1990 · N6774Q · DestroyedNTSB LAX90DXQ02Accident · Minor injuriesFinal reportLeffler/Mcfarlane LM-1 · Sierraville, CAPilot's failure to see and avoid a tree during his landing approach.Jul 30, 1990 · N9646Z · DestroyedNTSB NYC90LA168Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Gt. Barrington, MAThe pilot's failure to maintain adequate clearance from tree during the precautionary landing. Factor was a loss of thermal lift.Jul 21, 1990 · N2724H · Substantial damageNTSB FTW90DPJ09Accident · No injuriesFinal reportSchweizer SGS 2-33A · Norman, OKThe pilot's misjudgement of proper glidepath.Jul 8, 1990 · N65879 · Substantial damageNTSB LAX90LA208Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Truckee, CAThe pilot's improper decision to release from the tow airplane at an insufficient altitude on the lee side of the mountains.Jun 4, 1990 · N2423W · Substantial damageNTSB FTW90LA110Accident · Serious injuriesLimited investigationFinal reportAdams A60S · Austin, TXImproper planning/decision by the pilot. The unfavorable wind and obstacles were related factors.May 27, 1990 · N9811N · Substantial damageNTSB LAX90LA130Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Byron, CAThe pilot's inadequate visual lookout for objects along the landing runway.Mar 31, 1990 · N3837J · Substantial damage