NTSB investigations: Jabiru 3300

7 cases on aircraft whose registry engine model is Jabiru 3300, where the probable cause includes Performance/control parameters, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

NTSB investigations: Jabiru 3300 per year, 2008–2026: 7 cases
2008	1
2010	1
2011	2
2015	2
2016	1

Where

Open the map

Latest cases

Query with SQL

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 f."inProbableCause" AND starts_with(f."findingCode", '01062000'))) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 f.\"inProbableCause\" AND starts_with(f.\"findingCode\", '01062000')))
  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 f."inProbableCause" AND starts_with(f."findingCode", '01062000')))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR17LA015Accident · No injuriesLimited investigationFinal reportRyan W Gross Arion Lighting · Mesa, AZThe pilot's failure to maintain airplane control during takeoff/initial climb due to his inexperience in the airplane make and model and his refusal to obtain training in the airplane.Oct 22, 2016 · N235SC · Substantial damage NTSB CEN15FA315Accident · 2 fatalField investigationFinal reportSanford Zenith CH 601XL · Bristol, WIThe pilot’s failure to maintain airspeed and airplane control following a loss of engine power during cruise flight. Contributing to the accident was the installation of ignition system coils that were not engine-manufacturer replacement parts, which…Jul 25, 2015 · N9601 · Substantial damage NTSB GAA15CA052Accident · No injuriesData collectionFinal reportArion Lightning LS-1 · West Plains, MOThe pilot's failure to maintain control while landing in gusty wind conditions.Apr 21, 2015 · N332AL · Substantial damage NTSB CEN11CA447Accident · Minor injuriesData collectionFinal reportArion Lightning LS-1 · Garden City, KSThe pilot's failure to maintain aircraft control while landing.Jul 3, 2011 · N125GD · Substantial damage NTSB CEN11CA215Accident · No injuriesData collectionFinal reportArion Lightning · Brownsville, TXThe pilot’s failure to maintain adequate airspeed on final approach, resulting in a loss of control and a hard landing.Mar 2, 2011 · N125GD · Substantial damage NTSB CEN10FA182Accident · 1 fatalField investigationFinal reportCzech Aircraft Works Spol Sro Mermaid · Algonac, MIThe pilot’s loss of control resulting from an aerodynamic stall/spin while maneuvering at low altitude.Apr 1, 2010 · N853CZ · Destroyed NTSB SEA08LA149Accident · 1 fatalLimited investigationFinal reportVan Heeswyk Lightning · Marana, AZThe insufficient clamping force resulting in a fatigue fracture of the propeller extension attachment bolts and subsequent separation of the propeller assembly in flight. Contributing to the accident was the pilot's failure to maintain sufficient airspeed to…Jun 1, 2008 · N62JV · Substantial damage