Final NTSB investigations, ND
13 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1990 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2007 | 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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 CHI07CA161Accident · No injuriesData collectionFinal reportWeatherly 201C · Mc Clusky, NDThe pilot's failure to check for fuel contamination during the preflight inspection, which resulted in a loss of engine power shortly after takeoff due to water contamination. Contributing factors to the accident included the rough/uneven field and the…NTSB CHI98LA241Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fort Ransom, NDA loss of engine power due to fuel exhaustion. Factors contributing to this accident were the pilot's failure to ensure the airplane had enough fuel to complete the flight, and the fence.NTSB CHI97LA037Accident · No injuriesLimited investigationFinal reportCessna 150 · Bowbells, NDthe pilot's failure to lean the mixture control after applying carburetor heat as the pilot's operating handbook states should be done. The carburetor icing conditions and the terrain were factors.NTSB CHI93LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, NDThe student pilot's delayed use of carburetor heat. The soft terrain in the landing area was a factor.NTSB CHI90DTG05Accident · No injuriesFinal reportPiper PA-25-235 · Sykeston, NDThe pilot's inadequate aircraft preflight. Contributing to the accident was the lack of suitable terrain on which to perform a forced landing.NTSB DEN88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDNTSB DEN88LA060Accident · No injuriesLimited investigationFinal reportCessna 150L · Reynolds, NDNTSB DEN87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Emerado, NDThe commercial plt was en route on a personal flt. Thirteen miles from his destination, he smelled oil fumes and the cabin filled with oil smoke. The engine oil pressure dropped to zero. The plt shut down the engine, ventilated the cabin, and declared an…NTSB DEN86LA091Accident · No injuriesLimited investigationFinal reportCessna 175 · Kulm, NDAccording to the plt, the eng lost partial pwr on takeoff due to carberetor ice. A forced landing was made during which the nose gear collapsed resulting in substantial damage to the acft.NTSB DEN85LTG08Accident · Minor injuriesFinal reportPiper PA-28-140 · Underwood, NDThe acft nosed over during a forced landing following a loss of pwr. The plt stated he was practicing slow flt on the return flt from picking the acft up after an annual inspection. As the acft slowed to 90 mph during slow flt, the plt attempted to increase…NTSB DEN85LA071Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Grand Forks, NDOn Sunday 1/27/85 at approximately 0849 MST, a Beech DUCHESSN1850S, on lease to the university of north dakota crashed after takeoff from the Grand Forks airport, Grand Forks, ND.the student pilot and certified flight instructore were not injured. Two…NTSB DEN84FTG01Accident · No injuriesFinal reportLee M. Brown Taterbug SB-1 · Sawyer, NDThe plt switched from main tank to aux tank, & about 10 minutes later, the eng began losing power switching back to the main tank did not help. The engine continued running but at greatly reduced power. A forced landing was made in a frozen stubble field. The…NTSB DEN82DA091Accident · No injuriesFinal reportCessna 180 · Backoo, NDThe pilot flew to the vicintiy of his destination by following the path of recent showers. He was a farmer and was interested in the amount of standing water. He had arranged to fly over a friend's house so the friend would pick him up at the airport. After…