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 ('1152736')
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 ('1152736')
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 GAA16CA060Accident · No injuriesData collectionFinal reportBeech 56 · Hudson, COThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the distraction of the open cabin door.NTSB NYC06FA079Accident · 1 fatalField investigationFinal reportBeech 56TC · Winfield, WVThe pilot's inadequate preflight preparation to ensure an adequate supply of supplemental oxygen, and his inadequate in-flight planning and decision making, which resulted in exhaustion of his oxygen supply, and incapacitation from hypoxia during cruise…NTSB NYC03LA155Accident · Serious injuriesLimited investigationFinal reportBeech BE-56TC · Bethany, WVA total loss of power in the right engine for undetermined reasons. A factor was a partial loss of power in the left engine due to a loose oil line.NTSB FTW97LA200Accident · No injuriesLimited investigationFinal reportBeech BE-56TC · Spring, TXThe pilot's failure to perform an adequate preflight (did not remove pitot tube protective covering prior to flight) which resulted in an inaccurate cockpit airspeed indication during takeoff roll and subsequent emergency landing. Factors were, the pilot's…NTSB NYC91LA101Accident · No injuriesLimited investigationFinal reportBeech 56TC · New Haven, CTFailure of the pilot to maintain directional control after the nose wheel steering system failed.NTSB FTW84LA333Accident · Minor injuriesLimited investigationFinal reportBeech 56TC · Houston, TXA special ferry permit had been issued for a one time flt. According the plt neither eng was developing normal power during or after takeoff. At appx 300 ft AGL the acft began to descend and the plt initiated the forced landing in the wooden terrain about 5…NTSB LAX84FA058Accident · 4 fatalField investigationFinal reportBeech 56TC · San Diego, CADuring arrival, the plt was cleared for an ILS apch to rwy 28R. About 3 min later, he commenced a missed apch & requested another ILS to rwy 28. At that time, the ATC controller advised the plt that the 5 preceding acft had made ILS apchs & all had executed…NTSB NYC83LA046Accident · No injuriesLimited investigationFinal reportBeech 56TC · Gasport, NYDuring the takeoff roll from a snow covered runway the aircraft slid to the left of the runway and into a snow bank. The left main and nose gear collapsed.NTSB CHI82FA146Accident · No injuriesField investigationFinal reportBeech 56TC · Chicago, ILThe pilot stated that during landing, the touchdown was smooth. Shortly after touchdown, the left wheel began to wobble and thump and the aircraft started to veer to the left. Reportedly, the right brake would not hold the aircraft on the runway. The aircraft…NTSB CHI82DA062Accident · No injuriesFinal reportBeech 56TC · Huntington, INDuring a night touch and go landing, the aircraft veered left and struck a snowberm as the pilot was adding power to takeoff. Snowberms were located inside of the runway lights making the usable runway less than 75 ft and possibly restricting the lighting.…NTSB MIA81FLD56Accident · No injuriesClosedBeech 56TC · Arcadia, FLNTSB CHI80FEP02Accident · Minor injuriesClosedBeech 56TC · Middleton, WINTSB MIA79FA070Accident · 2 fatalClosedBeech 56TC · Howey In Hills, FLNTSB CHI77DEM30Accident · No injuriesClosedBeech 56TC · Traverse City, MINTSB FTW77FPG11Accident · No injuriesClosedBeech A56TC · Ft.Smith, ARNTSB MIA76F1A05Accident · No injuriesClosedBeech 56TC · Destin, FLNTSB CHI74AC074Accident · No injuriesClosedBeech 56TC · Grand Rapids, MINTSB MIA73FLD30Accident · No injuriesClosedBeech 56TC · Daytona Beach, FLNTSB MIA73DKJ14Accident · No injuriesClosedBeech 56TC · Russelville, ALNTSB MIA73FKW03Accident · No injuriesClosedBeech 56TC · Springfield, TNNTSB MIA72DLD10Accident · No injuriesClosedBeech 56TC · Crystal River, FLNTSB MIA71FKC46Accident · No injuriesClosedBeech 56TC · Atlanta, GANTSB MKC70DDM17Accident · No injuriesClosedBeech 56TC · Rochester, MNNTSB CHI70F0191Accident · No injuriesClosedBeech 56T · Flushing, MINTSB FTW69A0063Accident · 5 fatalClosedBeech 56TC · San Antonio, TXNTSB CHI69D0440Accident · No injuriesClosedBeech 56TC · Rockford, IL
Back to Beech 56TC