Skip to content

NTSB investigations: NONE, SD

12 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

19792026

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" = 'SD' 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\" = 'SD' 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" = 'SD' 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 CEN24LA369Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe balloon landing in increased wind, which resulted in a hard landing and the serious injury of a passenger.Sep 27, 2024 · N605KD · No damage NTSB CEN23LA302Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe pilot’s weather encounter that resulted in a high speed landing, the balloon tipping over, and serious injury to a passenger.Jul 12, 2023 · N605KD · No damage NTSB CEN22LA238Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Hot Springs, SDThe passenger lost her grip during landing in a balloon which resulted in her hitting the ground with her shoulder and suffering a serious injury.Jun 8, 2022 · N9158Z · No damage NTSB CHI07LA317Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Custer, SDThe high wind during landing. Contributing to the accident was the encounter with adverse weather during the flight.Jul 17, 2007 · N5069B · No damage NTSB CHI04LA204Accident · No injuriesLimited investigationFinal reportAerostar S53H · Sioux Falls, SDThe pilot's selection of an unsuitable landing area for the balloon and his failure to maintain clearance with the transmission line. A contributing factor was the presence of the transmission line.Jul 8, 2004 · N5001J · Substantial damage NTSB CHI02LA216Accident · Serious injuriesLimited investigationFinal reportAerostar International S-77A · Custer, SDThe pilot of the balloon did not maintain aircraft control. Factors contributing to the accident include the variable winds and the inadequate compensation for the wind conditions by the pilot in command.Jul 27, 2002 · N2867W · No damage NTSB CHI00LA295Accident · Serious injuriesLimited investigationFinal reportAerostar S-81A · Custer, SDThe ground crew's failure to maintain control of the balloon until all passengers were disembarked. A factor related to the accident was the gust of wind.Sep 12, 2000 · N9174Z · Minor damage NTSB CHI97LA108Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Sioux Falls, SDthe ground crewmember failed to maintain visual contact with the balloon, while it was landing. A factor relating to the accident was: the ground crewmember allowed her attention to be diverted while keeping a child out of harms way.Apr 20, 1997 · N71493 · No damage NTSB CHI95LA262Accident · Serious injuriesLimited investigationFinal reportAerostar S-81-A · Custer, SDthe pilot's inadequate evaluation of the weather conditions.Aug 8, 1995 · N9174Z · Substantial damage NTSB DEN82DTK07Accident · Serious injuriesFinal reportRaven RX-7 · Phillip, SDAfter the fourth landing, the balloon had been on the ground about 8 minutes when a whirl wind suddenly hit the envelope. The balloon lifted up about 2 to 3 ft and was blown into the side of a chase vehicle. One of the passengers was thrown out of the…Aug 22, 1982 · N4010S · Minor damage NTSB MKC80DTK07Accident · Serious injuriesClosedRaven RX-7 · Chancellor, SDDec 22, 1979 · N2910R · No damage NTSB MKC79DTK18Accident · Serious injuriesClosedRaven RX-6 · Sioux Falls, SDJul 10, 1979 · N1882R · No damage