NTSB investigations: Jabiru 3300
11 cases on aircraft whose registry engine model is Jabiru 3300, where NTSB found Not determined, general. 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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 2 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 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 ('34801', '34802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '05000000')))
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 ('34801', '34802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '05000000')))
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 CEN22FA375Accident · 1 fatalClass 3 · FieldFinal reportSonex Waiex · Maxwell, CAA loss of control in flight for undetermined reasons that resulted in an impact with terrain.NTSB ERA21LA166Accident · Serious injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Fort Pierce, FLA total loss of engine power for reasons that could not be determined based on available information.NTSB ERA20CA201Accident · No injuriesClass 4 · Data collectionFinal reportJabiru J250-SP · Gulf Of MexicoA total loss of engine power due to a fuel leak that could not be identified since the wreckage was not recovered.NTSB WPR17LA148Accident · No injuriesLimited investigationFinal reportCharles J Norris Arion Lightning · New River, AZA partial loss of engine power for reasons that could not be determined due to a lack of available evidence.NTSB ERA17LA016Accident · Serious injuriesLimited investigationFinal reportHatcher Roderick R CH701 · Albrightsville, PAA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB ERA16LA285Accident · Minor injuriesLimited investigationFinal reportShaffer Donald Arion Lightning · Toughkenamon, PAA total loss of engine power for reasons that could not be determined because examination of the engine did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR14CA087Accident · No injuriesData collectionFinal reportPrizio Texas Sprt CUB TX11J · Avalon, CAA total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered.NTSB CEN11LA618Accident · No injuriesLimited investigationFinal reportVicari Waiex · Marion, ILThe partial loss of engine power during initial climb for undetermined reasons.NTSB CEN11IA235Incident · No injuriesIncident investigationFinal reportSchlichtman Stol CH750 · Cassville, MOThe fatigue failure of the propeller hub retaining bolts due to insufficient clamping force .NTSB ERA09LA329Accident · 2 fatalLimited investigationFinal reportSorenson Lightning · Brevard, NCBoth pilots failure to maintain adequate airspeed while maneuvering after a loss of engine power for undetermined reasons, which resulted in an aerodynamic stall.NTSB DEN08LA054Accident · No injuriesLimited investigationFinal reportMacAdams Titan Tornado 912 · Rock Springs, WYThe loss of engine power for undetermined reasons. Contributing to the accident was the snow covered ravine.