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 ('1151422')
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 ('1151422')
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 ANC26LA060Accident · No injuriesClass 4 · LimitedInvestigation openBeech E33 · Steamboat Springs, CONTSB ERA25LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech E33 · Lenoir, NCThe mechanic’s inadequate annual inspection of the airplane and failure to comply with an applicable airworthiness directive, which resulted in a total loss of engine power due to oil starvation.NTSB CEN12LA675Accident · No injuriesLimited investigationFinal reportBeech E33 · Greeley, COThe loss of engine power for reasons that could not be determined during postaccident examinations and testing.NTSB WPR12FA012Accident · 3 fatalField investigationFinal reportBeech E33 · Daggett, CAA loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…NTSB WPR09LA043Accident · 1 fatalLimited investigationFinal reportCessna 170B · Hanna, UTThe flight's encounter with adverse tailwinds and downdrafts in mountainous terrain that exceeded the airplane's climb capability.NTSB MIA99LA145Accident · No injuriesLimited investigationFinal reportBeech E33 · Orlando, FLthe pilot's failure to maintain control of the airplane during takeoff, resulting in the airplane departing the runway, and subsequently impacting with an airport sign.NTSB LAX93FA118Accident · 1 fatalField investigationFinal reportBeech E33 · Avalon, CAThe pilot's alcoholic impairment of efficiency and judgement which resulted in his attempt to perform aerobatics at night in hilly terrain at an altitude inadequate for terrain clearance.NTSB DEN90LA183Accident · 1 fatalLimited investigationFinal reportBeech E 33 · Tulsa, OKThe pilot's failure to select the right tank prior to the approach resulting in fuel starvation.NTSB CHI89IA180Incident · No injuriesIncident investigationFinal reportBeech E33 · Chicago, ILThe failure of the controller to clarify the confusing communications, to correct the pilot's misinterpretation of the instructions being given, and the failure of the supervisor to properly monitor the situation. Factors related to the incident were the…NTSB DEN89FA152Accident · 1 fatalField investigationFinal reportBeech E33 · Angel Fire, NMImproper planning/decision by the pilot, his premature rotation for takeoff and subsequent failure to obtain or maintain sufficient speed to climb, and his failure to abort the takeoff (while there was sufficient rwy remaining). Contributing factors were: the…NTSB LAX89LA097Accident · No injuriesLimited investigationFinal reportBeech E33 · Parlier, CAThe pilot's improper in-flight planning/decision to continue to the destination airport after encountering a restrictionof fuel flow from the right tank and subsequent fuel starvation when the left tank emptied. Contributing factors were the blocked fuel vent…NTSB LAX85FVA05Accident · No injuriesFinal reportBeech E-33 · Coalinga, CAThe acft dragged the tail and crashed in a plowed field about 1/4 mile east of the takeoff rwy. The plt said the acft became 'squirrely' on the rwy and went left off the rwydespite her application of rt rudder tracks showed that the acft left rwy after 250 ft…NTSB FTW83FA221Accident · No injuriesField investigationFinal reportBeech E33 · San Angelo, TXThe eng failed in flt & the acft crashed 1 mi short of rwy 18 during an emergency landing into mathis arpt. The acft's fuselage was streaked with fresh oil. The rigid oil pressure line, extending from the eng to the firewall, failed due tofatigue cracking…NTSB FTW83LA064Accident · No injuriesLimited investigationFinal reportBeech E33 · Little Rock, ARDuring the landing roll, all three of the landing gear retracted as the pilot was applying brakes to turn off at the first exit. FAA inspectors found the landing gear handle in the down position with the circuit breaker popped. The flaps were also found in…NTSB MIA79FA032Accident · 2 fatalClosedBeech E33 · Arcadia, FLNTSB MIA77FLG24Accident · No injuriesClosedBeech E33 · St Matthews, SCNTSB CHI75DEM14Accident · No injuriesClosedBeech E33 · Holland, MINTSB IAD71II029Incident · No injuriesClosedBeech E33 · Washington, DCNTSB MKC71DCG02Accident · Minor injuriesClosedBeech E33 · Bolivar, MONTSB NYC70DFD25Accident · No injuriesClosedBeech E33 · Edgartown, MANTSB CHI70F0395Accident · Minor injuriesClosedBeech E33 · Milan, ILNTSB OAK70A0026Accident · 2 fatalClosedBeech E33 · Carson City, NVNTSB IAD70A0005Accident · 1 fatalClosedBeech 35-E33 · Jarrettsville, MDNTSB LAX69D0231Accident · No injuriesClosedBeech E33 · Blythe, CANTSB CHI69D0198Accident · No injuriesClosedBeech E33 · Kankakee, ILNTSB FTW68F0578Accident · No injuriesClosedBeech 35-E33 · Houston, TX
Back to Beech E33