NTSB investigations, SD
7 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1987 | 1 |
|---|---|
| 1994 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 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\" = 354)
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" = 354) 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 CHI00LA108Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Arlington, SDthe CFI's improper use of the throttle control during a simulated loss of engine power emergency. A factor associated with the accident was the rough terrain on which the forced landing was conducted.NTSB CHI99LA355Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Hermosa, SDthe pilot's improper fuel management, improper in-flight decision and the precautionary landing. Factors relating to this accident were the pilot's inadequate preflight planning and the fence post.NTSB CHI98LA235Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Spearfish, SDthe pilots improper preflight planning, which failed to detect the fuel selector positioned on the left fuel tank, which had insufficient fuel, resulting in fuel starvation, and the loss of engine power.NTSB CHI96LA056Accident · Minor injuriesLimited investigationFinal reportMaule M-4 · Hot Springs, SDan unauthorized modification of the air induction system by the pilot.NTSB CHI95LA193Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Rapid City, SDthe pilot's failure to feather the propeller on the left engine during the descent. A factor was the carburetor icing weather condition.NTSB CHI95LA014Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Aberdeen, SDthe pilot's failure to assure adequate maintenance was performed on the airplane and the resulting intentional flight with known deficiencies. Factors associated with the accident were the pilot's failure to follow the aircraft flight manual and the improper…NTSB DEN87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Milbank, SDThe private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed…