NTSB investigations: Beech B19
20 cases on aircraft the registry lists as Beech B19, where the first occurrence was “Hard landing”. 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 |
|---|---|
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1989 | 3 |
| 1991 | 2 |
| 1993 | 3 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 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.\"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\" = 200))
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" = 200))
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 IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.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 NYC96LA180Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, MEthe student pilot's improper flare, which resulted in at hard landing.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 CHI93LA210Accident · No injuriesLimited investigationFinal reportBeech B19 · Janesville, WIThe pilot's improper landing flare.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 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 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 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 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 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 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 CHI82DA296Accident · No injuriesFinal reportBeech B19 · Le Suer, MNThe aircraft landed short of the runway collapsing the nose gear and damaging the propeller.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.