NTSB investigations: Revmaster 2100, CA
14 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
| 1981 | 1 |
|---|---|
| 1982 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2007 | 1 |
| 2010 | 2 |
| 2011 | 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\" = 'CA' 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" = 'CA' 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 WPR11FA155Accident · 1 fatalField investigationFinal reportMuse KR2 · Newberry Springs, CAThe airplane’s encounter with severe turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.NTSB WPR10CA181Accident · No injuriesData collectionFinal reportMorrison Joseph Q2 · Frazier Park, CAA partial loss of engine power likely due to the failure of the oil pump.NTSB SEA07CA271Accident · Minor injuriesData collectionFinal reportLangley Tri-Quickie · Chino, CAThe premature rotation of the airplane on the takeoff roll as a result of the pilot failing the verify the elevator trim position, resulting in a loss of control and subsequent impact with terrain during an aborted takeoff.NTSB LAX02LA051Accident · No injuriesLimited investigationFinal reportVernon Sonerai IIL · Camarillo, CAFailure of the pilot to maintain directional control on the landing rollout. Factors were the owner/pilot's inadequate remedial design changes and the freshly plowed field.NTSB LAX00LA078Accident · Minor injuriesLimited investigationFinal reportMyers Q-2 · Compton, CAFailure of the pilot to maintain directional control of the airplane during the takeoff roll.NTSB LAX99LA303Accident · 1 fatalLimited investigationFinal reportNye KR-2 · Mariposa, CAThe pilot's failure to maintain an adequate airspeed margin while performing an intentional steep right bank turning maneuver, which resulted in a stall/mush and descent into terrain.NTSB LAX98LA265Accident · No injuriesLimited investigationFinal reportRaymond C. Voegele Mini IMP RC-2 · Sonoma, CAA loss of power due to a loose magneto cap and a binding throttle control cable. The deficiencies were the result of the owner/pilot's improper installation and/or adjustments.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 LAX94LA378Accident · No injuriesLimited investigationFinal reportQuickie-Myers Q2 · Van Nuys, CAthe pilot's inadequate landing flare, which resulted in a hard touchdown and buckling of the canard.NTSB LAX89DUG05Accident · No injuriesFinal reportSalmon KR-2 · Chino, CAThe pilot's overcontrolling of the aircraft. A factor in the accident was that this was the pilot's first flight in the aircraft.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).NTSB LAX83FUG10Accident · Serious injuriesFinal reportNorman Negus KR-2 · Hemet, CAThe owner of the home built aircraft was checking out the other pilot who was second-in-command (SIC). The SIC also had a home built of the same make and model. The objective was to provide familiarization to the SIC. During an approach to land, they elected…NTSB LAX81FUA09Accident · Minor injuriesClosedRand KR2 · Huntington Bch, CA