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 ('1154006')
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 ('1154006')
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 CEN25FA006Accident · 1 fatalClass 3 · FieldFinal reportBeech C99 · Norfolk, NEThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the fatigue failure of the compressor turbine fan disk blade.NTSB ERA24FA097Accident · Serious injuriesClass 3 · FieldFinal reportBeech C99 · Londonderry, NHThe pilot’s failure to ensure that the cockpit door was secured before flight, which resulted in its separation during initial climb and a subsequent loss of control.NTSB ERA23FA346Accident · 2 fatalClass 3 · FieldFinal reportBeech C-99 · Litchfield, MEA horizontal stabilizer pitch trim anomaly that was not identified in the available evidence.NTSB CEN23LA363Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C-99 · Lansing, MIThe pilot’s failure to properly set the rudder trim position which resulted in a loss of directional control during takeoff. Contributing was the pilot’s inadequate checklist procedures prior to takeoff.NTSB ANC21LA030Accident · No injuriesClass 4 · LimitedFinal reportBeech C-99 · Chignik Lagoon, AKThe pilot’s failure to visually inspect the runway condition before landing, which resulted in a collision with an ice chunk and main landing gear separation during landing.NTSB GAA18CA167Accident · No injuriesData collectionFinal reportBeech C99 · Hastings, NEThe pilot's decision to land in a gusty crosswind that exceeded the airplane's maximum demonstrated crosswind and resulted in a runway excursion.NTSB CEN17LA123Accident · No injuriesLimited investigationFinal reportBeech C 99 · Durango, COThe pilot's inability to maintain directional control during takeoff in crosswind conditions on a contaminated runway, which resulted in a runway excursion.NTSB WPR16LA155Accident · No injuriesLimited investigationFinal reportBeech C 99 · Spanish Fork, UTAn in-flight collision with power lines.NTSB WPR15LA203Accident · No injuriesLimited investigationFinal reportBeech C 99 · Salt Lake City, UTThe airplane’s unmanageable right yaw during takeoff for reasons that could not be determined because postaccident examination of the rudder and rudder assembly did not reveal any anomalies that would have precluded normal operation.NTSB OPS10IA574Incident · No injuriesIncident investigationFinal reportBeech C-99 · Minneapolis, MNThe Local North Controller's issuance of a left-turn heading to the Airbus without establishing the position and heading of the Beech. Contributing to the incident was the Local South Controller's distraction with a ground movement operation and lack of…NTSB CEN10LA090Accident · No injuriesLimited investigationFinal reportBeech C-99 · Kearney, NEThe failure of the pilot to maintain adequate airspeed during the approach resulting in a stall. Contributing to the accident was the accumulation of structural icing during the flight.NTSB WPR10IA045Incident · Minor injuriesIncident investigationFinal reportBeech C-99 · Show Low, AZAn in-flight collision with a bird during initial descent.NTSB SEA06FA068Accident · 2 fatalField investigationFinal reportBeech C99 · Butte, MTThe second pilot's failure to follow the published instrument approach procedure and the captain/PIC's inadequate supervision. Snow and mountain obscuration were factors.NTSB LAX02LA030Accident · No injuriesLimited investigationFinal reportBeech C-99 · Flagstaff, AZThe pilot's failure to maintain adequate airspeed and his failure to maintain directional control. Contributing factors were the icing conditions, icing, and the improper use of the anti-ice/deicing equipment.NTSB SEA01IA093Incident · No injuriesIncident investigationFinal reportBeech C-99 · Salem, ORA short to electrical wiring while in cruise flight.NTSB LAX99FA096Accident · 1 fatalField investigationFinal reportBeech C99 · Bishop, CAthe pilot's failure to follow procedures and directives and his failure to maintain clearance from mountainous terrain.NTSB LAX98FA013Accident · No injuriesField investigationFinal reportBeech 99-C99 · Meadview, AZThe pilot's inadequate in-flight decision, inadequate visual lookout, and his failure to maintain adequate obstacle clearance. Contributing was low altitude flight.NTSB ANC96LA076Accident · Minor injuriesLimited investigationFinal reportBeech 99C · Barrow, AKan in-flight collision with a bird.NTSB LAX95FA035Accident · 1 fatalField investigationFinal reportBeech C-99 · Avenal, CAloss of aircraft control at night by the pilot for unknown reasons.NTSB CHI93MA143Accident · 2 fatalMajor investigationFinal reportBeech C99 · Shelton, NEThe deliberate disregard for the federal aviation regulations, gp express procedures, and prudent concern for safety by the two pilots in their decision to execute an aerobatic maneuver during a scheduled check ride flight, and the failure of gp express…NTSB SEA93LA067Accident · No injuriesLimited investigationFinal reportBeech C-99 · Seattle, WAThe improper starting procedure by the pilot of the Aeronca. A factor contributing to the accident was inadequate communications by the pilot of the Aeronca.NTSB ANC92LA123Accident · No injuriesLimited investigationFinal reportBeech C99 · Nuiqsut, AKThe pilot's improper inflight planning/preparation, and his failure to attain the proper touchdown point. Contributing to the accident was the downdraft.NTSB ATL92MA118Accident · 3 fatalClass 1 · MajorFinal reportBeech C99 · Anniston, ALThe failure of senior management of gp express to provide adequate training and operational support for the startup of the southern operation, which resulted in the assignment of an inadequately prepared captain with a relatively inexperienced first officer…NTSB DCA91MA042Accident · 13 fatalMajor investigationFinal reportBeech C99 · Birmingham, ALThe decision of the captain to initiate and continue an instrument approach into clearly identified thunderstorm activity, resulting in a loss of control of the airplane from which the flightcrew was unable to recover and subsequent collision with obstacles…NTSB LAX90LA036Accident · No injuriesLimited investigationFinal reportBeech C-99 · Ontario, CAImproper use of the brakes by the pilot of the Piper PA-31.NTSB MIA88IA068Incident · No injuriesIncident investigationFinal reportBeech 99 · Tampa, FLThe commuter air carrier crew received an unsafe nose gear indication on final approach. The approach was abandoned and all efforts to use the emergency extension procedures were to no avail. The crew secured both engines on final and landed nose gear up.…NTSB MIA88IA028Incident · No injuriesIncident investigationFinal reportBeech 99 · Gulfport, MSWhile on a part 135 scheduled domestic passenger flt during final apch, the nose landing gear failed to fully extend. The plt recycled the gear, but the gear failed to fully extend. He then attempted to lower the gear using the emergency method, again, with…NTSB DEN87IA031Incident · No injuriesIncident investigationFinal reportBeech C-99 · Albuquerque, NMMesa airline flt 114 was on a scheduled flt from Albuquerque to clovis, NM. Upon touchdown at clovis, the left landing gear began to collapse and a go-around was successful. The crew elected to return to Albuquerque where emerg equipment could stand by. After…NTSB DEN86FA137Accident · No injuriesField investigationFinal reportBeech BE-99C · Laramie, WYThis part 135 IFR flt was inbound for landing at Laramie, Wyoming. During the en route and approach for ldg portions of the flt the acft picked up a moderate to heavy load of ice. During the landing flare the acft stalled, hit the rwy, bounced, veered off the…NTSB NYC84IA002Incident · No injuriesIncident investigationFinal reportBeech C99 · Burlington, VTThe plt stated that after a smooth touchdown on the main gear, a loud bang was heard, accompanied with a gear unsafe horn. A go-around was made, & after completing emerg gear extension procedure the acft returned for landing. During landing the left gear…
Back to Beech C-99