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 NYC93LA073Accident · No injuriesLimited investigationFinal reportBeech B19 · Old Bridge, NJThe pilot's improper flare and improper recovery from a bounced landing, which resulted in overload failure of the nose gear.NTSB BFO92LA140Accident · No injuriesLimited investigationFinal reportBeech 19 · Revere, PAThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB FTW92LA053Accident · No injuriesLimited investigationFinal reportBeech B19 · Bonham, TXInadvertent stall during the forced landing approach. A factor was the partial loss of power for undetermined reasons.NTSB FTW92FA025Accident · No injuriesField investigationFinal reportBeech B19 · Forth Worth, TXInadequate visual lookout by the pilots-in-command of both aircraft, which resulted in their failure to see-and-avoid the other aircraft. A factor related to the accident was: failure of the developmental controller or the supervisor to provide adequate…NTSB FTW91LA148Accident · No injuriesLimited investigationFinal reportBeech B19 · Poteau, OKThe improper flare technique utilitzed by the pilot under instruction. A factor was the failure of the check pilot to intervene.NTSB FTW91LA135Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Mesquite, TXThe flight instructor's inadequate supervision of the student. Factors were the dual student's misjudgement of altitude and premature flare of the airplane.NTSB SEA91LA169Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Bend, ORPoor preflight planning/preparation by the pilot in command. Factors to the accident were: high density altitude, excessive climb rate, inadequate remedial action, and lack of total flight expereince.NTSB FTW91LA110Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Addison, TXEntry door opening in flight, inadequate emergency procedures published by the manufacturer, and poor emergency training by the student's instructor. Factors were inadequate design/installation of the door locking mechanism, deteriorated airplane performance,…NTSB FTW90LA173Accident · No injuriesLimited investigationFinal reportBeech BE19 · Dallas, TXThe instructor pilot's failure to maintain crew coordination in the cockpit, and the student pilot's premature retraction of the flaps during a critical maneuver. Factors were the certified flight instructors inadequate supervision and the inadvertent low…NTSB NYC90LA195Accident · Serious injuriesLimited investigationFinal reportBeech BE-19 · Shirley, NYFailure of the PIC to supervise the actions of the dual student.NTSB FTW90LA132Accident · No injuriesLimited investigationFinal reportBeech B19 · Mc Kinney, TXInadequate supervision by the PIC, the instructor pilot, when he allowed the student pilot to flare at too high an altitude off the runway.NTSB MIA90LA094Accident · No injuriesLimited investigationFinal reportBeech B-19 · Everglades City, FLThe pilots failure to flare the aircraft for landing resulting in the nose landing gear contacting the runway causing it to separate.NTSB LAX90LA107Accident · No injuriesLimited investigationFinal reportBeech B-19 · Chiriaco Summit, CAA engine compartment fire of undetermined origin dduring engine start.NTSB ATL90LA039Accident · No injuriesLimited investigationFinal reportBeech B19 · Muscle Shoals, ALThe premature flare initiated by the student pilot and the flight instructor's delay in taking remedial action, which led to an inadvertent stall and a hard landing.NTSB FTW89LA173Accident · No injuriesLimited investigationFinal reportBeech B-19 · Mckinney, TXPilot's improper technique in recovery from a bounced landing. Factors contributing to the accident were the pilot's failure to maintain directional control during the go around.NTSB NYC89FA121Accident · 1 fatalField investigationFinal reportBeech B19 · Augusta, MEFailure of the pilot to maintain the proper altitude during the approach. A factor related to the accident was: the pilot's psychological condition.NTSB DEN89LA052Accident · No injuriesLimited investigationFinal reportBeech 19 · Santa Fe, NMThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB MIA88LA242Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Greenville, MSThe pilot reported that while on short final during a personal flt, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a levee, small trees, then the terrain.NTSB ATL88LA128Accident · No injuriesLimited investigationFinal reportBeech B19 · Albany, KYThe plt reported that he touched down about midfield on the 1,800 ft usable portion of the rwy. A light rain was falling at the time, and the rwy was wet. Braking action was poor, and the airplane subsequently overran the runway. The airplane traveled down an…NTSB MKC87LA157Accident · No injuriesLimited investigationFinal reportBeech B19 · Little Rock, ARThe instructor said they were on an instructional flight practicing accuracy landings when they lost airspeed, added power, and ran out of stabilator. The student said the instructor was demonstrating a short field landing when they lost airspeed and hit…NTSB NYC87LA214Accident · No injuriesLimited investigationFinal reportBeech B19 · Augusta, METhe student plt rprtd that during a practice landing, he rounded out too high. Subsequently, the acft bounced hard & the nose gear collapsed. After coming to rest, the plt exited the acft, but a fire erupted & the acft was destroyed.NTSB ATL86LA225Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Ardmore, ALDuring the landing attempt, the pilot elected to go-around after he realized that a safe landing could not be completed. During the go-around the acft settled to the rwy after the pilot retracted the flaps. The acft rolled off the departure end of the rwy at…NTSB CHI86LA190Accident · No injuriesLimited investigationFinal reportBeech B-19 · Manchester, MIThe pilot states, that on flare out the aircraft ballooned and then settled, sustaining a hard landing. The nose gear failed upon touchdown.NTSB LAX86LA269Accident · No injuriesLimited investigationFinal reportBeech B-19 · Scottsdale, AZThe acft was fast and long during a landing attempt according to the student plt. He elected to make a go-around but in doing so he raised the flaps too rapidly and the acft landed hard after which it bounced into the dirt off to the side of the rwy.NTSB LAX85IA370Incident · No injuriesIncident investigationFinal reportBeech B19 · Van Nuys, CAAfter departure, at about 800 feet, the right airleron became disconnected. The pilot was able to make a left turn, fly a left hand traffic pattern and land successfully. Examination of the aircraft revealed that the right inboard aileron control push rod had…NTSB CHI84LA253Accident · No injuriesLimited investigationFinal reportBeech B-19 · Oshkosh, WIThe student pilot stated that he rounded out a little high, while landing on rwy 09, stalled & contacted the runway in a crabbed position. A hard landing resulted which substantially damaged the aircraft.NTSB NYC84LA173Accident · No injuriesLimited investigationFinal reportBeech B19 · Danbury, CTThe plt stated while performing the last landing of the day a gust of wind blew the left wing up as the acft was being flared. The acft landed hard and bounced back into the air. A go-around was initiated but when another taxing acft was viewed in the…NTSB NYC83LA119Accident · No injuriesLimited investigationFinal reportBeech Sport · Bangor, METhe acft ran off the runway and collapsed the landing gear during landing. The student pilot had made 7 successful landings. On this final landing a gust of wind blew the acft across the runway and the pilot lost direction control. The acft went off the left…NTSB CHI83LA191Accident · No injuriesLimited investigationFinal reportBeech BE-19-180 · Champaign, ILThe acft drifted across the runway in a crosswind and collided with a runway light. The student pilot had taken off on runway 22 for his first solo flight. The tower changed runways according to the pilot and made 04 the active. The wind was 150 degrees at 8…NTSB ATL82FID13Accident · No injuriesFinal reportBeech B-19 · Franklin, VAN7698R crashed while on final approach, approximately one half mile east of Franklin airport. The father of the pilot stated that the aircraft had been taken without permission. The pilot holds an expired student pilot certificate. In addition, the pilot was…NTSB CHI82DA296Accident · No injuriesFinal reportBeech B19 · Le Suer, MNThe aircraft landed short of the runway collapsing the nose gear and damaging the propeller.NTSB NYC82FA175Accident · 1 fatalField investigationFinal reportBeech B19 · South Yarmouth, MAThe acft stalled & impacted trees as the plt was buzzing a residence at 150-200 ft above the tree tops.NTSB CHI82DA263Accident · No injuriesFinal reportBeech B19 · Berrien Springs, MIDuring landing, the aircraft bounced and the pilot lost directional control. Subsequently, the aircraft departed the left side of the runway, went into a muddy area, and was substantially damaged.NTSB SEA82DA084Accident · No injuriesFinal reportBeech B19 · Quincy, WADuring a simulated forced landing, the student pilot initially turned the wrong direction, then turned correctly toward the runway. He was lower then normal at his initial and downwind points but after being prompted by the instructor (ip), the student angled…NTSB CHI82DA140Accident · No injuriesFinal reportBeech BE-19 · Ridgeville, WIThe student pilot departed oshkosh, WI on a round robin cross country flight. The flight was destined for rockford, IL, lacrosse, WI and oshkosh. The aircraft departed oshkosh with full fuel tanks and was not refueled en route. The total duration of the…NTSB MKC82DA066Accident · No injuriesFinal reportBeech B-19 · West Union, IAThe pilot was flying his newly purchased aircraft from cedar rapids, Iowa to West Union, Iowa. He had purchased the aircraft on the previous day and had received a checkout from the seller. The pilot reported that when he was on final approach, the aircraft…NTSB FTW82FPG08Accident · 2 fatalFinal reportBeech 19 · Little Rock, ARThe aircraft departed north Little Rock airport sometime after 1745 and was not seen or heard from again. At approximately 1900 a witness 5 miles from the airport heard the sound of a light aircraft increasing and decreasing power just before the sound of…NTSB CHI82DEV03Accident · No injuriesClosedBeech B19 · Savoy, ILNTSB CHI81FER68Accident · No injuriesClosedBeech B19 · Eden Prairie, MNNTSB CHI81DER69Accident · No injuriesClosedBeech B19 · Hibbing, MNNTSB DEN81DTE34Accident · No injuriesClosedBeech B19 · Longmont, CONTSB NYC81FGM17Accident · No injuriesClosedBeech B19 · Bridgeville, PANTSB ATL81FIA01Accident · No injuriesClosedBeech B19 · Indianhead, MDNTSB CHI81DEV02Accident · No injuriesClosedBeech B19 · Sidney, ILNTSB MIA80FKJ39Accident · No injuriesClosedBeech B19 · Panama City, FLNTSB FTW81FPA18Accident · No injuriesClosedBeech B19 · Dallas, TXNTSB ANC80DAG99Accident · No injuriesClosedBeech B19 · Anchorage, AKNTSB CHI80FER65Accident · No injuriesClosedBeech B19 · Eden Prairie, MNNTSB LAX80DXQ38Accident · No injuriesClosedBeech B19 · S.Lake Tahoe, CANTSB NYC80DA063Accident · No injuriesClosedBeech B19 · Tewksbury, MA
Back to Beech B19