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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('5872018')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('5872018')
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 CEN23LA238Accident · No injuriesClass 4 · LimitedFinal reportMooney M10 · Gassville, ARThe pilot’s failure to maintain control of the airplane during takeoff with a quartering tailwind.NTSB ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.NTSB ANC06LA030Accident · 1 fatalLimited investigationFinal reportMooney M-10 · Salinas, CAThe pilot's continued flight into known adverse weather, and his failure to maintain sufficient airspeed, which resulted in a loss of control and an inadvertent stall/spin during cruise flight. Factors associated with the accident are a low ceiling with…NTSB NYC03FA021Accident · 2 fatalField investigationFinal reportMooney M10 · Fairfield, NJThe inadequate visual lookout of both pilots. Factors in the accident were the FAA controller's failure to provide a traffic advisory, the improper decision among the three controllers to leave only one controller in the cab, and night conditions.NTSB FTW90LA180Accident · No injuriesLimited investigationFinal reportMooney M-10 · Roscoe, TXThe pilot's loss of directional control. A factor was: rough/uneven terrain.NTSB FTW86LA081Accident · No injuriesLimited investigationFinal reportMooney M-10 · Abilene, TXWhile on final approach for runway 17 at elmdale airpark, Abilene, TX, the student pilot lost control of the aircraft when he flared the aircraft and it began to descend. The student attempted to pull back on the wheel, causing the aircraft to enter a stall…NTSB MKC78DCJ07Accident · Minor injuriesClosedMooney M10 · Emerson, NENTSB MKC78DCJ05Accident · Serious injuriesClosedMooney M10 · Wayne, NENTSB MKC77FCJ41Accident · Serious injuriesClosedMooney M10 · South Sioux, NENTSB SEA74DYC60Accident · No injuriesClosedMooney M10 · Lebanon, ORNTSB MKC73DER47Accident · No injuriesClosedMooney M10 · Willmar, MNNTSB CHI73FCQ21Accident · No injuriesClosedMooney M-10 · Springfield, KYNTSB CHI73FEM10Accident · No injuriesClosedMooney M10 · Greenville, MINTSB NYC73AN005Accident · 3 fatalClosedMooney M10 · Bridgeport, WVNTSB SEA71DWG33Accident · No injuriesClosedMooney M10 · Wenatchee, WANTSB SEA70AS042Accident · 1 fatalClosedMooney M10 · Wolf Creek, OR
Back to Mooney M10