Fatal NTSB investigations: Beech G18S
15 cases on aircraft the registry lists as Beech G18S. 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
| 1964 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1989 | 1 |
| 1996 | 1 |
| 2012 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151010'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151010'))
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 CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…NTSB MIA97LA036Accident · 1 fatalLimited investigationFinal reportBeech 18G · Roosevelt Roads, PRThe pilot's improper planning/decision concerning separation of the left engine cowling. Factors relating to the accident were: the pilot's failure to perform weight and balance calculations, and/or to ensure the airplane was loaded in accordance with company…NTSB ATL89FA098Accident · 1 fatalField investigationFinal reportBeech BE-18 · Covington, KYPilot attempted a takeoff with coating of frost on the airframe which resulted in a loss of lift during climbout.NTSB CHI83FA381Accident · 2 fatalField investigationFinal reportBeech G18S · Evart, MIThe acft collided with a utility pole and a large tree during a forced landing after a power loss on takeoff. Witnesses heard the acft backfiring and the ground run was excessively long. Immediately after takeoff the acft went through the tops of pine trees.…NTSB NYC81FA050Accident · 2 fatalClosedBeech G18S · Hyannis, MANTSB OAK79FA013Accident · 2 fatalClosedBeech G18S · Sacramento, CANTSB MKC79FA004Accident · 2 fatalClosedBeech G18S · Hays, KSNTSB MIA77FA081Accident · 1 fatalClosedBeech G18S · Aero Oasis Apt, FLNTSB ANC76AA114Accident · 5 fatalClosedVolpar C18S · Dutch Harbor, AKNTSB CHI76AC065Accident · 7 fatalClosedBeech G-18S · West Chicago, ILNTSB MIA75AM066Accident · 1 fatalClosedBeech G18S · Troy, ALNTSB LAX71AL060Accident · 5 fatalClosedBeech G18S · Grnd Canyon, AZNTSB MIA70A0014Accident · 1 fatalClosedBeech C-45G · Brentwood, TNNTSB NYC68A0107Accident · 7 fatalClosedBeech G18S · Weston, VTNTSB UNK64X2869Accident · 4 fatalClosedBeechcraft G18S · Toadlena, NM