Skip to content

NTSB investigations: NONE, MN

21 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

19652026

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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CEN24LA139Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S53A · Rochester, MNThe pilot’s failure to maintain clearance from power lines while landing in a field.Mar 21, 2024 · N5236R · Substantial damage NTSB CEN11CA398Accident · Serious injuriesData collectionFinal reportLindstrand LBL120A · Le Center, MNThe failure of the passenger to follow the pilot's instructions during landing, which caused the pilot to be ejected from the balloon and sustain serious injuries.Jun 17, 2011 · N5595L · Substantial damage NTSB CEN09CA475Accident · Minor injuriesData collectionFinal reportGlasflugel Standard Libelle · Faribault, MNThe pilot's inability to maintain proper airspeed on approach to land.Jul 26, 2009 · N3872 · Substantial damage NTSB CHI07CA233Accident · No injuriesData collectionFinal reportSchweizer SGS 1-35C · Northfield, MNThe pilot's failure to maintain adequate airspeed, which resulted in a stall during the off-airport landing. A factor contributing to the accident was the dirt/rock pile.Jul 20, 2007 · N135EX · Substantial damage NTSB CHI06LA208Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Claremont, MNThe procedure not followed by the passenger during landing and the inadequate supervision of the passenger by the pilot during landing. A contributing factors were the barbed wire fence.Jul 21, 2006 · N3639Q · No damage NTSB CHI05CA255Accident · No injuriesData collectionFinal reportLet L 33 Solo · Stanton, MNThe pilot's failure to maintain a proper descent rate during landing due to the wind gusts. The wind gusts were a factor.Jul 28, 2005 · N93205 · Substantial damage NTSB CHI03LA313Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Slayton, MNThe excessive descent rate during the balloon's landing by the student pilot.Aug 11, 2003 · N2789N · No damage NTSB CHI03LA147Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Cottage Grove, MNThe inadequate touchdown by the pilot.Jun 3, 2003 · N52461 · No damage NTSB CHI01LA250Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 STD Astir III · Faribault, MNThe pilot's failure to maintain adequate airspeed during the landing which resulted in a stall.Jul 29, 2001 · N3837U · Substantial damage NTSB CHI94LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Willmar, MNthe failure of the pilot in command to maintain directional control during touch and go landings. A factor was the pilot in command's lack of total experience and the snowbank located off the side of the runway.Apr 30, 1994 · N758ZC · Substantial damage NTSB CHI87LA002Accident · No injuriesLimited investigationFinal reportLet L-13 · White Bear Lake, MNThe plt reported that he entered the traffic pattern for rwy 30 at aprx 900 ft and completed a right turn to base. The plt stated that while on base, he realized the aircraft was too high and deployed the spoilers halfway. As he turned to final, he stated…Oct 8, 1986 · N142AS · Substantial damage NTSB CHI85LA367Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Blaine, MNThe one hour balloon sightseeing flight was uneventful. During his approach to land in a clear area he decided that his forward velocity was too high to land without hitting houses or powerlines below the balloon. According to him he burned fuel to attempt a…Sep 2, 1985 · N4196N · Substantial damage NTSB CHI84LA216Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes Firefly 8-24 · Burnsville, MNThe Balloon landed without incident. According to the plt, the envelope was being deflated when a gust of wind tipped the basket. The plt said he saw a young boy with his leg under the basket. The plt lifted the edge of the basket by stepping out of it to…May 27, 1984 · N3679A · No damage NTSB CHI83LA310Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Hamel, MNDuring flt, the plt used fuel from 2 of 4 propane tanks, then switched to the 2nd 2 tanks & started a descent. At aprx 300 ft AGL, he tried to start the burner, but could not get a light because the pilot light was out. He attempted to manually relight the…Jul 13, 1983 · N1509W · Substantial damage NTSB CHI80FER69Accident · Serious injuriesClosedCameron Viva · Chaska, MNSep 27, 1980 · N72CB · Destroyed NTSB MKC78DER71Accident · No injuriesClosedSchleicher K8B · Stanton, MNJul 8, 1978 · N221L · Substantial damage NTSB MKC78DER65Accident · Minor injuriesClosedSchweizer 2-33 · White Bear Lk, MNJun 18, 1978 · N2462W · Substantial damage NTSB MKC77FER34Accident · Serious injuriesClosedSchweizer SGU2 · Cloquet, MNApr 17, 1977 · N2717Z · Substantial damage NTSB MKC71DER76Accident · No injuriesClosedSchweizer 1-26 · Hayfield, MNJun 13, 1971 · N8603R · Substantial damage NTSB MKC67F0581Accident · No injuriesClosedSchweizer SGU-2 · Red Wing, MNMay 6, 1967 · N5823V · Substantial damage NTSB MKC66D0017Accident · No injuriesClosedCessna 140 · Lamberton, MNMay 30, 1965 · N89297 · Substantial damage