NTSB investigations: Beech E18S, CA
10 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
| 1968 | 2 |
|---|---|
| 1976 | 1 |
| 1977 | 3 |
| 1979 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 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\" = 'CA' 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" = 'CA' 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 LAX88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Los Angeles, CAWhile taxiing after landing, N911E was instructed to taxi to a position and hold, en route to that position, the acft collided with N75397 that was also holding in the same position. The plt of N911E stated that he did not see the acft due to moisture that…NTSB LAX84LA245Accident · No injuriesLimited investigationFinal reportBeech E18S · Buellton, CAThese acft collided in flt while being ferried. The weather was VMC. N8711 was damaged substantially and N753CW receivedminor damage. Both acft landed at santa ynez arpt where N8711 lost control during rollout and ran off the rwy. N753CW was landed with the…NTSB LAX83LA200Accident · No injuriesLimited investigationFinal reportBeech E-18S · Davis, CAWhile in flt on a parachute jumping mission, a fire erupted in the right eng area & a precautionary landing was made. An exam revealed that the float fulcrum screw, pn 13773, on the stromberg carburetor had backed out & allowed fuel to escape into the exhaust…NTSB LAX80DUG12Accident · No injuriesClosedBeech E18S · Laverne, CANTSB LAX77FA065Accident · 2 fatalClosedBeech E18S · Catalina Is, CANTSB OAK77FVA51Accident · No injuriesClosedBeech E18S · Santa Nella, CANTSB LAX77DUG39Accident · Minor injuriesClosedBeech E185 · Chino, CANTSB LAX76IL077Incident · No injuriesClosedBeech E18S · San Diego, CANTSB LAX69A0034Accident · No injuriesClosedBeech E18S · Los Angeles, CANTSB LAX68A0065Accident · 3 fatalClosedBeech E18S · San Diego, CA