NTSB investigations: NONE, 1998

5 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Miscellaneous/other”. 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, 1998 per year, 1982–2026: 72 cases
19822
198411
19852
19865
19872
19881
19893
19901
19914
19925
19931
19952
19966
19975
19985
19991
20014
20034
20041
20053
20061
20073

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\") = 1998
    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\" = 430))
  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 DEN99LA028Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Canon City, COThe glider pilot's failure to follow proper preflight procedures, and his failure to control the aircraft when the latch opened during flight. A factor was his failure to properly latch the canopy, and to utilize all available runway during the forced landing.Dec 27, 1998 · N173SS · Substantial damageNTSB IAD98LA105Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Freehold, NJThe passenger's failure to secure himself during landing.Aug 29, 1998 · N9067F · No damageNTSB NYC98LA199Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly AX-9 · Brookhaven, NYThe failure of the passenger to comply with the pilot briefing, and properly brace herself for landing.Aug 15, 1998 · N3141C · No damageNTSB FTW98LA301Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin II · Refugio, TXThe pilot's inadvertent ground loop. A factor was the pilot's failure to follow procedures in securing the rear canopy, which resulted in the canopy opening in flight.Jul 5, 1998 · N103GG · Substantial damageNTSB CHI98LA171Accident · No injuriesLimited investigationFinal reportStemme S10V · Plymouth, WIthe improper in-flight decision of the pilot in command to initiate a turn at a close proximity to the ground. Factors to the accident were the starting procedures not being followed and the inadequate altitude to initiate the engine restart.May 19, 1998 · N97MT · Substantial damage