NTSB investigations: Starduster SA-300
5 cases on aircraft the registry lists as Starduster SA-300. 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
| 1972 | 1 |
|---|---|
| 1984 | 1 |
| 1994 | 1 |
| 2000 | 1 |
| 2003 | 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.aircraft_model_code IN ('86601MP', '86601MR'))
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.aircraft_model_code IN ('86601MP', '86601MR'))
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 LAX03CA301Accident · No injuriesData collectionFinal reportStarduster SA300 · Quincy, CAthe pilot's failure to maintain directional control of the airplane, which resulted in a ground loop.NTSB NYC01LA015Accident · Serious injuriesLimited investigationFinal reportMoore Starduster SA-300 · Erwinna, PAA total loss of engine power during initial climb for undetermined reasons.NTSB NYC94LA158Accident · No injuriesLimited investigationFinal reportStulp Starduster SA 300 · Ottawa, OHinadequate maintenance which resulted in a corroded gascolator fuel screen restriction fuel flow and resulted in fuel starvation.NTSB FTW84LA231Accident · Minor injuriesLimited investigationFinal reportStarduster SA-300 · El Paso, TXWhile in the arpt traffic pattern for landing, the plt experienced an engine failure and landed short of the rwy. The acft collided with a sand dune. The plt stated that he had experienced a loss of fuel pressure on previous flts but had not corrected the…NTSB MIA73FKGO7Accident · 2 fatalClosedStarduster SA300 · Peachtree City, GA