Final NTSB investigations, ND
11 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1999 | 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\" = 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" = '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" = 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 CHI99LA162Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Buxton, NDthe number one cylinder's separation, the pilot's visual lookout not possible through the oil given off by the number one cylinder, and the embankment. A factor in the accident was the oil.NTSB CHI96FA216Accident · No injuriesField investigationFinal reportFairchild SA227AC · Grand Forks, NDinsufficient clearance between the second stage compressor impeller and the shroud. A factor was the subsequent fatigue failure of the impeller.NTSB CHI95LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Lakota, NDPartial loss of engine power due to preignition and/or detonation, which resulted in failure of the number 4 cylinder. The unfavorable tailwind for landing was a related factor.NTSB CHI93DTG02Accident · No injuriesFinal reportAero Commander S2R · Hoople, NDA loss of engine power due to a cracked engine cylinder.NTSB CHI93FA028Accident · Minor injuriesField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Wahpeton, NDOther maintenance personnel's improper maintenance (installation).NTSB CHI93DTG01Accident · No injuriesFinal reportKing BOWERS-FLYBABY · Buffalo, NDPartial loss of engine power due to improper installation of the carburetor, by the pilot/owner.NTSB CHI92DTG04Accident · No injuriesFinal reportGrumman G-164B · Grandin, NDThe cracked cylinder which resulted in a forced landing. The lack of suitable terrain on which to make an emergency landing was a factor.NTSB DEN87LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Grafton, NDPlt made forced landing on dirt road shortly after takeoff when the eng reportedly lost power. Plt extended landing gear but acft touched down before gear locked and left main landing gear collapsed. Left wing also struck a mailbox during rollout. Post…NTSB DEN86LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fargo, NDThe plt reports that the flt was descending through 7,000 ft approaching the dest arpt when the eng began to run rough and lost pwr. The flt continued toward to the arpt but was unable to reach the rwy and landed about 1/4 mi short. After touchdown the acft…NTSB DEN84LA270Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Grand Forks, NDDuring initial takeoff climb at an alt of aprx 100 ft AGL, engine began missing. Unable to maintain alt, forced landing was made in a plowed field during which landing gear was torn from the acft. Inspection revealed #5 cylinder head separated from the…NTSB DEN82DA040Accident · Serious injuriesFinal reportBell 206B III · Trenton, NDThe aircraft was hovering during a sling load operation when the engine lost power. The pilot released the load but due to low rotor RPM the aircraft landed hard, substantially damaging the aircraft. Investigaton revealed a failure of the forward male splines…