NTSB investigations: Beech B19, MI
5 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.
Cases per year
| 1974 | 1 |
|---|---|
| 1982 | 1 |
| 1986 | 1 |
| 1993 | 1 |
| 2006 | 1 |
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.\"eventStateOrRegion\" = 'MI' 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" = 'MI' 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" 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 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 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 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 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 CHI75FEC23Accident · No injuriesClosedBeech B19 · Pontiac, MI