NTSB investigations, SD
6 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1997 | 2 |
| 2004 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'SD' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310) 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 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.NTSB CHI97LA109Accident · No injuriesLimited investigationFinal reportCessna 421C · Pierre, SDthe pilot's inadvertent activation of the number one throttle/power control. Factors were: the pilot left the cockpit unattended with the engines running and a wet ramp.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.NTSB DEN85FA002Accident · 3 fatalField investigationFinal reportHamburger Flugzeugbau Hansa HFB-320 · Aberdeen, SDThe hansa jet HFB-320 acft crashed on takeoff from the Aberdeen airport after the flt crew selected the incorrect rwy for takeoff. The acft was observed running off the end of rwy 17, which is 3860 ft long, where it struck a fence, ditch, road & another ditch…NTSB DEN84LA233Accident · No injuriesLimited investigationFinal reportCessna A188B · Stratford, SDPlt stated that he was taking off on this flight with 120 gallons of chemical and full fuel tanks. He continued to state that the acft did not accelerate as it had earlier that day. The acft rolled aprx 3 quarters of the 1/2 mile long rwy before it became…NTSB DCA84AA012Accident · 1 fatalFinal reportDouglas DC-9-31 · Sioux Falls, SDDuring landing the crew acquired visual reference with the ground & apch lights about 200 ft AGL, followed by visual sighting of the rwy. Since the ATIS reported blowing snow, the crew expected to see, & was not surprised to see, snow blowing across the rwy…