NTSB investigations: Revmaster 2100, MT
5 cases on aircraft whose registry engine model is Revmaster 2100. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1992 | 1 |
| 1996 | 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\" = 'MT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52550'))
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" = 'MT' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52550'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA00LA068Accident · No injuriesLimited investigationFinal reportPZL-Bielsko SZD-45A Ogar · Libby, MTA crack in the propeller blade that developed into a complete separation of the blade.NTSB SEA96LA212Accident · 1 fatalLimited investigationFinal reportGrazier Quickie 2 · Superior, MTloss of engine power after takeoff for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering to return to the departure airport, which resulted in a stall and collision with wooded terrain.NTSB SEA92LA103Accident · No injuriesLimited investigationFinal reportE.E. Shilling Q-2 · Billings, MTAn undetermined loss of engine power.NTSB DEN86LA228Accident · No injuriesLimited investigationFinal reportE. E. Schilling Q-2 · Billings, MTPlt stated after accident that he had a minor eng problem prior to departure from big timber. He stated that the problem was corrected and the flight commenced to Billings. While on final approach to rwy 04 at Billings the plt experienced a partial loss of…NTSB DEN85FTI01Accident · 1 fatalFinal reportPolliwagen 2 Place · Manhattan, MTThe acft crashed in an open flt shortly after takeoff and was destroyed by fire. There were no witnesses to the accident. The plt reportedly stated he needed to depart Manhattan by 0500 MST to arrive in helena before 0600 MST when the ATC twr opened as his…