NTSB investigations: Revmaster 2100
10 cases on aircraft whose registry engine model is Revmaster 2100, where the first occurrence was “Loss of engine power”. 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52550')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52550')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 SEA04LA046Accident · Minor injuriesLimited investigationFinal reportJerome Q-2 · Hillsboro, ORThe pilot's inadequate evaluation of deteriorating weather conditions (increasing rain) and his failure to maintain the proper rate of descent on landing (long/hard touchdown). Contributing factors were carburetor icing conditions and rain.NTSB LAX00LA139Accident · No injuriesLimited investigationFinal reportScovil KR-2 · Tonopah, AZThe fuel control metering unit becoming disengaged and the inadvertent use of the fuel supply during flight.NTSB CHI99LA127Accident · No injuriesLimited investigationFinal reportReindl Quickie 2 · Olathe, KSThe loss of engine power for undetermined reasons. A factor associated with the accident is the lack of suitable terrain for a forced landing.NTSB LAX98LA194Accident · No injuriesLimited investigationFinal reportScott Dragonfly · Mecca, CAThe pilot's inadequate preflight inspection and his failure to ensure sufficient fuel was in the airplane, which subsequently led to fuel exhaustion. A related factor was the soft terrain.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 NYC95LA124Accident · 1 fatalLimited investigationFinal reportBailey Quickie Q-2 · Woodsfield, OHThe loss engine power for undetermined reason and the pilot's failure to maintain control which resulted in an inflight collision with terrain.NTSB SEA92LA103Accident · No injuriesLimited investigationFinal reportE.E. Shilling Q-2 · Billings, MTAn undetermined loss of engine power.NTSB MIA90FA043Accident · Serious injuriesField investigationFinal reportTundermann Venne Q-2 · Zephyrhills, FLLoss of engine power for undetermined reasons.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 LAX85FUG02Accident · No injuriesFinal reportCorlett-Beahm KR-2 · Riverside, CAThe acft nosed over in a field during a forced landing following a loss of power which occurred for unknown reason(s).