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 ('1155402', '1155404')
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 ('1155402', '1155404')
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 CEN24LA115Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 400 · Bentonville, ARImproper rigging of the elevator cable over the upper guard pin, which resulted in a cable separation and loss of elevator control.NTSB GAA23WA010IncidentClass 5 · ForeignBeech 400A · Cornwall, United KingdomNTSB ERA12LA401Accident · Serious injuriesLimited investigationFinal reportBeech 400A · Atlanta, GAThe flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…NTSB ENG06IA020Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400A · Norfolk, VAHigh-altitude ice crystals that had accreted on the compressor vanes and were ingested into the engine high pressure compressor when the pilots retarded the power levers causing compressor surges and the flameouts of both engines. Contributing factors were…NTSB NYC99FA091Accident · Serious injuriesField investigationFinal reportRaytheon Corporate Jets BE-400A · Beckley, WVThe pilot-in-command misjudged his altitude and airspeed which resulted in an overrun. Contributing to the accident were the pilot's lack of total flight experience in make and model, the pilot's reliance on the airplane's optional thrust reverser system and…NTSB BFO94LA050Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHThe pilots failure to use the proper radio frequency to activate the airport runway lights, and the pilot's improper decision to continue his approach and land without the runway lights being on.NTSB NYC80FA022Accident · 1 fatalClosedMaule 235C · Eagle Lake, MENTSB MIA76FLA63Accident · No injuriesClosedBell 47D-1 · Campbellton, FLNTSB FTW75DPG79Accident · No injuriesClosedBell 47D-1 · Walnut Ridge, ARNTSB IAD75ALQ03Accident · Minor injuriesClosedBell 47D1 · Clinton, KYNTSB MKC73FCA28Accident · No injuriesClosedBell 47D1 · Dorena, MONTSB SEA69I0041Incident · No injuriesClosedBoeing 727 · Seattle, WANTSB FTW68A0080Accident · No injuriesClosedBell 47D1 · Greenville, TXNTSB MIA68A0022Accident · No injuriesClosedBell 47D1 · Glen Allan, MSNTSB FTW67A0103Accident · No injuriesClosedBell 47D1 · Irving, TXNTSB MKC67D0115Accident · Minor injuriesClosedPiper PA-22 · Cheney, KSNTSB FTW66A0039Accident · No injuriesClosedBell 47D1 · Snyder, TXNTSB UNK64X0761Accident · No injuriesClosedPiper PA22 · Newburg, MDNTSB UNK64X0113Accident · No injuriesClosedBell 47D1 · Dallas Tex, TX
Back to Beech 400A