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 ('1151215')
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 ('1151215')
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 ERA26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Umatilla, FLThe failure of the right main landing gear during the landing roll, which resulted in a loss of control on the ground and collision with an airport sign.NTSB WPR24LA221Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Running Springs, CAThe pilot’s decision to maneuver the airplane at a low altitude toward rising terrain, which exceeded the climb capability of the airplane.NTSB CEN24LA130Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Oklahoma City, OKThe student pilot’s improper landing flare, which resulted in a bounced landing, aerodynamic stall, and impact with the runway.NTSB CEN23LA264Accident · No injuriesClass 3 · LimitedFinal reportBeech B19 · Scott City, KSA partial loss of engine power as a result of carburetor icing that formed while the engine was operating at a low power setting for an extended period before departure.NTSB ERA22LA101Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Lebanon, TNThe failure of the certified flight instructor to attain the proper glidepath which resulted in a collision with a fence and terrain.NTSB WPR21LA139Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Twin Falls, IDThe pilot’s failure to maintain airplane control during initial climb with a crosswind when the airspeed decreased, the airplane exceeded its critical angle of attack and aerodynamical stalled at too low an altitude for the pilot to recover before the…NTSB ERA20LA344Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Laconia, NHThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.NTSB GAA20CA042Accident · No injuriesData collectionFinal reportBeech 19 · Somerville, TNThe pilot's failure to move the fuel selector position to the "on" position before takeoff, which resulted in a total loss of engine power and necessitated a forced landing to a field shortly after takeoff, and his subsequent improper decision to take off…NTSB GAA19CA438Accident · No injuriesData collectionFinal reportBeech 19 · Columbia Station, OHThe pilot's failure to see and avoid tall grass along the side of the runway during the takeoff roll, which resulted in his loss of directional control, a runway excursion, and nose-over.NTSB GAA19CA109Accident · No injuriesData collectionFinal reportBeech B19 · Los Angeles, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with a fence.NTSB GAA18CA116Accident · No injuriesData collectionFinal reportBeech B19 · Meadville, PAThe student pilot’s failure to maintain directional control during landing.NTSB CEN17LA179Accident · Minor injuriesLimited investigationFinal reportBeech 19 · Weatherford, TXThe flight instructor’s inadequate in-flight fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB ERA15LA334Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Dexter, METhe flight instructor’s inadequate preflight planning, which resulted in collision with trees and terrain during takeoff.NTSB CEN15LA172Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Osage Beach, MOThe failure of the No. 4 piston wrist pin plug and the subsequent entry of its metal shavings into the oil system, which clogged the oil passages and caused the engine to seize. Contributing to the accident was the installation of engine parts that were not…NTSB WPR13CA124Accident · No injuriesData collectionFinal reportBeech B19 · Ephrata, WAThe student pilot's failure to maintain directional control during the takeoff ground roll in crosswind conditions, and the flight instructor's delayed remedial action.NTSB ERA13CA073Accident · No injuriesData collectionFinal reportBeech B19 · Fort Lauderdale, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA11FA462Accident · Serious injuriesField investigationFinal reportBeech B19 · Whitesburg, GAThe student pilot did not retract the wing flaps during a go-around, which decreased the airplane’s climb performance and resulted in an in-flight collision with trees.NTSB ERA10LA297Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Rockohoma, NYThe pilot's inadequate preflight inspection which resulted in a total loss of engine power during the initial climb due to fuel contamination.NTSB ERA09CA493Accident · No injuriesData collectionFinal reportBeech B19 · Thomasville, PAA partial loss of engine power due to a partial blockage of the carburetor fuel inlet filter.NTSB CEN09CA320Accident · No injuriesData collectionFinal reportBeech B19 · Winsted, MNThe student pilot's improper flare during the soft-field landing. Contributing to the accident was the flight instructor's inadequate supervision during the landing.NTSB SEA08CA130Accident · No injuriesData collectionFinal reportBeech B19 · Burns, ORThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. The shifting wind was a factor.NTSB CHI06CA274Accident · No injuriesData collectionFinal reportBeech B19 · Pontiac, MIThe pilot's failure to perform a go-around when he noticed the airplane was not on a stabilized final approach. Contributing factors to the accident were the hard landing, the subsequent pilot-induced oscillation (porpoise) which resulted in the collapse of…NTSB CHI06CA261Accident · No injuriesData collectionFinal reportBeech B19 · Eden Prarie, MNThe pilot not maintaining directional control of the airplane during the landing. A factor was the ditch.NTSB LAX03LA153Accident · No injuriesLimited investigationFinal reportBeech B19 · Chandler, AZthe pilot's failure to maintain directional control on the landing roll due to his inadvertent use of brakes.NTSB DEN02FA106Accident · 1 fatalField investigationFinal reportBeech B19 · Delta, COthe pilot's failure to properly plan and compensate for the high density altitude conditions, resulting in partial engine power during takeoff, his failure to abort the takeoff, and his failure to maintain aircraft control on initial climb. Contributing…NTSB SEA02LA033Accident · No injuriesLimited investigationFinal reportBeech B-19 · Moses Lake, WAThe instructor's inadequate supervision of the student pilot. Also, the dual student's incorrect use of the fuel selector valve. A factor was the uneven terrain.NTSB ATL02LA002Accident · Minor injuriesLimited investigationFinal reportBeech 19 · St Clair Spring, ALThe pilot misjudged the touchdown point that resulted in the runway overrun.NTSB IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.NTSB CHI01FA209Accident · Minor injuriesField investigationFinal reportBeech B19 · Eden Prairie, MNThe student pilot's failure to maintain aircraft control during the landing, her failure to recover from the bounced landing, and the nose gear overload.NTSB NYC01LA074Accident · No injuriesLimited investigationFinal reportBeech B-19 · Louisa, VAThe pilot's failure to maintain airspeed, which resulted in a hard landing. Factor's in this accident were the loss of electrical power due to an alternator failure and the night light conditions.NTSB FTW01FA003Accident · 1 fatalField investigationFinal reportBeech B19 · Umbarger, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the low ceilings, the dark night illumination, the lack of visual cues, and the pilot's lack of instrument flight qualification or experience.NTSB CHI00LA290Accident · No injuriesLimited investigationFinal reportBeech B19 · Dodge Center, MNthe student pilot not maintaining aircraft control and the instructor pilot's delayed remedial action. A factor relating to the accident was the ditch.NTSB ATL00LA065Accident · No injuriesLimited investigationFinal reportBeech 19B · Tampa, FLThe loss of engine power for undetermined reasons. A factor was the weather conditions were favorable for the formation of carburetor ice. Contributing to the severity of the accident was the pilots lack of experience in the airplane which led to an…NTSB NYC00LA148Accident · No injuriesLimited investigationFinal reportBeech 19 · West Milford, NJThe pilot's failure to maintain directional control during the aborted landing.NTSB SEA00LA027Accident · Serious injuriesLimited investigationFinal reportBeech B-19 · Grand Coulee, WAThe pilot's failure to maintain clearance from power transmission lines. Factors include dark night conditions.NTSB CHI99LA191Accident · No injuriesLimited investigationFinal reportBeech B19 · Taylor, MOthe airplane pilot's and the helicopter pilot's failure to maintain visual clearance from each other while in the traffic pattern.NTSB FTW99FA020Accident · 2 fatalField investigationFinal reportBeech B19 · Hobart, OKThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain terrain clearance. Factors were the low ceiling, fog, dark night conditions, and the pilot's failure to obtain a weather briefing prior to the flight.NTSB FTW98LA282Accident · No injuriesLimited investigationFinal reportBeech B19 · Frisco, TXThe student pilot's improper landing flare which resulted in a hard larding. Factors were the inadequate supervision of the flight by the flight instructor and the high winds.NTSB MIA97LA183Accident · No injuriesLimited investigationFinal reportBeech B19 · New Smyrna Bch, FLthe private pilot's improper flare, which resulted in a hard landing and subsequent collapse of the left main landing gear and the nose gear.NTSB FTW97LA031Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Mckinney, TXthe pilot's inadequate preflight planning/preparation, by selecting a seat/cushion that would not allow adequate knee clearance and ankle movement in the cockpit, which was subsequently attributed to the pilot's failure to maintain directional control during…NTSB NYC96LA180Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, MEthe student pilot's improper flare, which resulted in at hard landing.NTSB FTW95LA342Accident · No injuriesLimited investigationFinal reportBeech 19 · Lago Vista, TXThe loss of engine power for undetermined reasons.NTSB CHI95LA129Accident · No injuriesLimited investigationFinal reportBeech B19 · Omaha, NEThe pilot misjudged distance and speed. A factor was turbulence.NTSB ATL95LA077Accident · Minor injuriesLimited investigationFinal reportBeech B-19 · Jackson, ALThe pilot's continued operation of the airplane with a known deficiency in available power.NTSB LAX94LA362Accident · No injuriesLimited investigationFinal reportBeech B19 · Big Bear City, CAthe failure and separation of the right main landing gear wheel assembly due to a preexisting and undetected crack.NTSB NYC93LA181Accident · No injuriesLimited investigationFinal reportBeech 19 · Wolfboro, NHThe pilot's failure to abort the takeoff which resulted in an overrun of the runway. Factors were a dirt bank, and the pilot's premature lift off, his failure to attain adequate airspeed, and his lack of recency of experience.NTSB CHI93LA338Accident · No injuriesLimited investigationFinal reportBeech 19 · Elkhart, INinadequate remedial action by the flight instructor. Factors related to the accident were the excessive descent rate and the overload failure of the landing gear.NTSB CHI93LA286Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Birmingham, MIAn improper grade of fuel was loaded into the airplane by the owner/operator of the rental airplane, improper planning and/or decision by the pilot, and subsequent vapor lock in the fuel system of the airplane (fuel system - other), which resulted in fuel…NTSB CHI93LA219Accident · No injuriesLimited investigationFinal reportBeech B19 · Victoria, MNThe loss of engine power due to a jammed carburetor float and the inability of the pilot to maintain clearance during the emergency landing.NTSB CHI93LA210Accident · No injuriesLimited investigationFinal reportBeech B19 · Janesville, WIThe pilot's improper landing flare.
Back to Beech B19