NTSB investigations: Beech B19
10 cases on aircraft the registry lists as Beech B19, where the first occurrence was “Loss of control - in flight”. 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.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1986 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 2000 | 2 |
Where
Open the mapLatest cases
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_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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151215')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151215')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 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 NYC00LA148Accident · No injuriesLimited investigationFinal reportBeech 19 · West Milford, NJThe pilot's failure to maintain directional control during the aborted landing.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 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 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 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 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 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 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 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…