Skip to content

NTSB investigations: NONE, NE

16 cases on aircraft whose registry engine model is NONE. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'NE' 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 ('00000')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"eventStateOrRegion\" = 'NE' 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 ('00000'))
  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.

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 c."eventStateOrRegion" = 'NE' 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 ('00000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN22LA159Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RXS-8 · Yutan, NEThe pilot’s improper brace during landing which resulted in a serious injury during the landing sequence.Mar 28, 2022 · N9106Q · Minor damage NTSB CEN17LA181Accident · 1 fatalLimited investigationFinal reportAS+ AC 4 · Blair, NEThe pilot's loss of control due to his diverted attention as he attempted to close the canopy that opened during initial climb.May 13, 2017 · N358R · Substantial damage NTSB CEN16LA352Accident · No injuriesLimited investigationFinal reportCameron Z90 · Morrill, NEThe pilot’s improper inflight fuel management, which resulted in fuel exhaustion and an inability to avoid contact with power lines.Sep 4, 2016 · N982ZS · Substantial damage NTSB CEN12CA393Accident · Serious injuriesData collectionFinal reportNational Ballooning 858 · Pierce, NEThe balloon pilot’s encounter with increased wind during landing, which resulted in a hard landing and a passenger’s injury.Jun 17, 2012 · N9005E · No damage NTSB CEN09CA328Accident · Serious injuriesData collectionFinal reportNational Ballooning 858 · Fremont, NEThe passenger’s inability to position herself properly for the normal balloon landing.May 31, 2009 · N31802 · No damage NTSB DFW08CA120Accident · No injuriesData collectionFinal reportHughes 269A · Lincoln, NEThe pilot's failure to properly execute a steep approach, which resulted in a tail strike and a loss of control.Apr 27, 2008 · N1020Q · Substantial damage NTSB CHI06CA160Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Gretna, NEA run-on landing encountered by the pilot of the balloon due to the prevailing winds. The unfavorable winds were a contributing factor.Jun 12, 2006 · N83030 · No damage NTSB CHI06CA029Accident · No injuriesData collectionFinal reportHughes 269A · Omaha, NEThe loss of engine power for an undetermined reason and the pilot's improper execution of the emergency procedure which resulted in an excessive descent rate and subsequent hard landing.Nov 5, 2005 · N1020Q · Substantial damage NTSB CHI05CA232Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Blair, NEThe low airspeed by the pilot and the inadequate supervision by the certified flight instructor.Aug 6, 2005 · N9295Z · Substantial damage NTSB CHI92LA293Accident · Serious injuriesLimited investigationFinal reportCameron O-77 · North Omaha, NEThe pilot's abrupt touchdown during a balloon landing. A related factor is the unsuitable terrain selected.Sep 27, 1992 · N9539G · No damage NTSB MKC81DCJ08Accident · No injuriesClosedSchleicher ASW-19 · Omaha, NEApr 2, 1981 · N10WH · Substantial damage NTSB MKC76FCJ55Accident · No injuriesClosedSchleicher K-7 · Lincoln, NEJul 28, 1976 · N8241E · Substantial damage NTSB MKC69F0454Accident · Serious injuriesClosedSchleicher KA7 · Scottsbluff, NEMay 24, 1969 · N4692T · Substantial damage NTSB MKC67D0053Accident · No injuriesClosedPrue 215A · Wilbur, NEJul 14, 1966 · N454Y · Substantial damage NTSB MKC65F0154Accident · 1 fatalClosedSchweizer SGS126 · Papillion, NEMay 16, 1965 · N2768R · Destroyed NTSB UNK64X2720Accident · No injuriesClosedSlingsby Lark 4 · Max, NEJul 8, 1964 · N135G · 2 aircraft · Substantial damage