NTSB investigations: Beech E18S, MO
9 cases on aircraft the registry lists as Beech E18S. 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
| 1973 | 2 |
|---|---|
| 1974 | 1 |
| 1975 | 1 |
| 1979 | 2 |
| 1982 | 1 |
| 1988 | 1 |
| 1994 | 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\" = 'MO' 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 ('1151006', '1151007'))
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" = 'MO' 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 ('1151006', '1151007'))
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 CHI95LA053Accident · 1 fatalLimited investigationFinal reportBeech E18S · Kansas City, MOFailure of the pilot to maintain adequate airspeed on final approach, which resulted in an inadvertent stall/spin. Factors related to the accident were: the adverse weather (icing) conditions, the accumulation of airframe/wing ice, the pilot's improper use of…NTSB MKC88FA059Accident · 2 fatalField investigationFinal reportBeech E18S · Vienna, MOThe plt rcvd a wx briefing bfr starting a ngt cargo opn in known icing conds. Bfr the flt, a line serviceman noticed ice on the acft's wings & suggested its removal, but the plt declined. Aprx 45 min after tkof, the plt rprtd to ARTCC that a de-ice boot had…NTSB MKC82IA128Incident · No injuriesIncident investigationFinal reportBeech E18S · Fenton, MOThe landing gear was reportedly down and locked prior to touchdown. A witness said the gear was down prior to touchdown but collapsed immediately after touchdown. Broken wires on the landing gear squat switch had disabled the ldg gear retraction system. A…NTSB MKC79FA042Accident · No injuriesClosedBeech E18S · Ft Wood, MONTSB MKC79FCA13Accident · No injuriesClosedBeech E18S · St Louis, MONTSB MKC76AK033Accident · 2 fatalClosedBeech E18S · Kansas City, MONTSB MKC75FCA15Accident · No injuriesClosedBeech E18S · Festus, MONTSB MKC74FCA15Accident · No injuriesClosedBeech E18S · F.Leonard Wood, MONTSB MKC74FCA06Accident · No injuriesClosedBeech E18S · St Louis, MO