NTSB investigations: Rotax 912ULS series
5 cases on aircraft whose registry engine model is Rotax 912ULS series, where the first occurrence was “Hard landing”. 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
| 2006 | 1 |
|---|---|
| 2007 | 4 |
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 ('55572')
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\" = 200))
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 ('55572')
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" = 200))
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 DEN08LA008Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Afton, WYThe pilot's failure to correct the alignment of the airplane and his improper recovery from a bounced landing, resulting in exceeding the design stress limits that caused the right main landing gear to fail. A contributing factor in this accident was the…NTSB DEN08LA024Accident · No injuriesLimited investigationFinal reportIniziative Industriali Italian Sky Aero 600 Sport · Stevensville, MDThe pilot's premature flare that resulted in a hard landing, fracturing the left main landing gear strut that subsequently collapsed. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB DEN07CA120Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Peyton, COThe pilot's improper flare and failure to maintain control and subsequent hard landing. Contributing factors in this accident were the gusty winds, hot temperature, and high density altitude.NTSB LAX07CA089Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Nampa, IDthe pilot's misjudged flare and improper use of the elevator flight control.NTSB CHI06CA226Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hillsdale, MIThe pilot's misjudged flare which resulted in the hard landing and his improper recovery from the bounced landing which resulted in the overload failure of the nose landing gear and subsequent nose over. The overload failure of the nose landing gear was a…