Skip to content

NTSB investigations: Beech B19, TX

22 cases on aircraft the registry lists as Beech B19. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19742026

Where

Latest cases

Query with SQL

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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151215')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151215'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 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.May 8, 2017 · N18925 · Substantial damage 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.Oct 12, 2000 · N5108R · Destroyed 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.Jun 21, 1998 · N5110R · Substantial damage 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…Oct 30, 1996 · N5102R · Substantial damage NTSB FTW95LA342Accident · No injuriesLimited investigationFinal reportBeech 19 · Lago Vista, TXThe loss of engine power for undetermined reasons.Aug 14, 1995 · N1946L · Substantial damage 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.Jan 3, 1992 · N2226L · Substantial damage 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…Nov 20, 1991 · N9343S · 2 aircraft · Substantial damage 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.Jul 31, 1991 · N1927L · Substantial damage 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,…Jun 28, 1991 · N18989 · Substantial damage 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…Sep 2, 1990 · N23848 · Substantial damage 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.Jul 3, 1990 · N18989 · Substantial damage 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.Sep 25, 1989 · N23848 · Substantial damage NTSB FTW81FPA18Accident · No injuriesClosedBeech B19 · Dallas, TXAug 31, 1980 · N24006 · Substantial damage NTSB FTW80FQG21Accident · No injuriesClosedBeech B19 · Lubbock, TXMay 26, 1980 · N6572R · Substantial damage NTSB FTW80DRG21Accident · No injuriesClosedBeech B19 · George West, TXJan 19, 1980 · N18956 · Substantial damage NTSB FTW79DQG29Accident · No injuriesClosedBeech 19 · Slaton, TXMar 30, 1979 · N1921W · Destroyed NTSB FTW77DQG60Accident · No injuriesClosedBeech 19 · Amarillo, TXSep 27, 1977 · N9252S · Substantial damage NTSB FTW76DQH10Accident · No injuriesClosedBeech A23-19 · Dalhart, TXSep 16, 1976 · N21FS · Substantial damage NTSB FTW76AF057Accident · 2 fatalClosedBeech B19 · Muleshoe, TXJan 11, 1976 · N9308S · Destroyed NTSB FTW75DRG93Accident · No injuriesClosedBeech B19 · Cotulla, TXJun 22, 1975 · N1996W · Substantial damage NTSB FTW75DPD38Accident · No injuriesClosedBeech B19 · Abilene, TXApr 29, 1975 · N6551R · Substantial damage NTSB FTW75DRG15Accident · No injuriesClosedBeech B19 · Victoria, TXAug 22, 1974 · N1995W · Substantial damage