NTSB investigations: Onan ALL MDLS A/B
4 cases on aircraft whose registry engine model is Onan ALL MDLS A/B, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 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 ('47850')
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\" = 250))
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 ('47850')
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" = 250))
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 MKC88LA083Accident · Minor injuriesLimited investigationFinal reportHyde Quickee · Creve Coeur, MOThe plt, flying the unfamiliar homebuilt canard type acft for the first time, said shortly after takeoff the acft began to buffet and sink. The acft then entered a steep bank and continued sinking until it struck the terrain. Corrective attempts by the plt to…NTSB FTW87DRG07Accident · Serious injuriesFinal reportNixon Quickie 1 · Del Rio, TXEarlier in the day, the plt had flown the home built acft on its maiden flt of 0.2 hrs with no rprtd problems. He stated that after taking off on the 2nd flt, he was climbing at aprx 200' AGL when the acft seemed to hit a gust of wind & roll left. He applied…NTSB MIA86FA091Accident · 1 fatalField investigationFinal reportSwanningson Quickie · Deland, FLThe acft was observed to takeoff & climb to about 300 ft, then roll to the left & descend to ground impact in an aprx 60 deg bank angle. The plt had stated that he was not feeling well just prior to departure, a witness stated that the plt had made several…NTSB MIA84LA029Accident · No injuriesLimited investigationFinal reportGary Wilson Quickie · Boca Raton, FLAccording to the plt, he had only 2 hrs flt time in quickie acft & this was his 1st flt in N114GW. He reported that after taking off, the acft tried to roll left. He used all available aileron to counteract the roll, but it was not effective. When impact was…