NTSB investigations, SD
5 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1990 | 1 |
| 2004 | 1 |
| 2005 | 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\" = 352)
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" = 352) 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 CHI06CA002Accident · No injuriesData collectionFinal reportCreed RV-4 · Mitchell, SDThe mechanic's improper installation of the air filter assembly which resulted in foreign debris inside the carburetor. A factor associated with the accident was the rough terrain on which the airplane was landed.NTSB CHI04TA193Accident · No injuriesFinal reportPZL-Mielec M-18T · Pine Ridge, SDThe propeller went to an overspeed condition as a result of contamination of the propeller control unit due to improper servicing by the operator and the mechanic. A factor was the hilly terrain.NTSB DEN90LA127Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Sisseton, SDA total loss of power due to fuel starvation. Fuel starvation was caused by a missing fuel valve support clamp and a resultant cracked fuel line. Inadequate maintenance inspections and rough, uneven terrain were contributing factors.NTSB DEN86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Onida, SDThe plt reported a partial loss of pwr occurred momentarily before liftoff. The takeoff was continued and once airborne the pwr loss reoccurred. The load was dumped, however, the acft impacted trees aprx 1 mile from the arpt as sufficient alt could not be…NTSB DEN83LA187Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Wagner, SDThe plt reported that the eng began loosing power as he approached his destination. He elected to make an emergency landing on a road to investigate the problem. He stated that he made a stalled landing that caused the tailwheel to unlock & allowed the acft…