NTSB investigations: Rotax 503 series, CA
8 cases on aircraft whose registry engine model is Rotax 503 series. 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
| 2007 | 1 |
|---|---|
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2017 | 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 ('55564'))
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 ('55564'))
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 GAA18CA054Accident · Minor injuriesData collectionFinal reportQuicksilver MXL Sport · Point Mugu, CAThe pilot’s failure to see and avoid power wires.NTSB WPR15FA140Accident · 1 fatalField investigationFinal reportQuicksilver Enterprises MXL II · Petaluma, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in an uncontrolled descent and structural failure. Contributing to the accident was the pilot's impairment from his use of diphenhydramine.NTSB WPR14CA017Accident · No injuriesData collectionFinal reportBeller Quicksilver Mxlii · Orland, CAThe pilot's failure to maintain aircraft control during taxi with a strong gusting wind condition which resulted in the airplane nosing over.NTSB WPR12LA441Accident · Minor injuriesLimited investigationFinal reportTeam MINI-MAX · Chula Vista, CAA complete loss of engine power as a result of fuel starvation due to an unsecured fuel filter, which moved in flight and kinked the flexible fuel line, severely restricting the fuel flow to the carburetor. Contributing to the accident was the inadequate…NTSB WPR11LA104Accident · Minor injuriesLimited investigationFinal reportBice Air Creation GTE · Hayfork, CAThe total loss of engine power during cruise flight, while operating in carburetor icing conditions.NTSB WPR09LA453Accident · 2 fatalLimited investigationFinal reportQuad City Challenger II · Redlands, CAStructural failure of the right wing during the landing approach due to the separation of the wing's fabric covering.NTSB WPR09LA130Accident · 1 fatalLimited investigationFinal reportToland S/Thornburgh J Twin 503SL · Torrance, CAThe passenger’s inadvertent activation of the engine throttle.NTSB SEA07LA266Accident · Serious injuriesLimited investigationFinal reportSt. Claire Ragtop-01 · Perris, CAThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing factors to the accident were the fence and the undetermined brake malfunction.