NTSB investigations: Aerofab LAKE 250
5 cases on aircraft the registry lists as Aerofab LAKE 250. 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
| 1996 | 1 |
|---|---|
| 2000 | 1 |
| 2003 | 3 |
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 ('5110322'))
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 ('5110322'))
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 NYC04CA002Accident · No injuriesData collectionFinal reportLake LA250 · Laconia, NHThe pilot's improper starting procedure. A factor in the accident was the pilot's lack of recent experience in make and model airplane.NTSB NYC03LA178Accident · No injuriesLimited investigationFinal reportAerofab Lake 250 · Phippsburg, METhe airplane's collision with a submerged object during a water landing.NTSB MIA03FA065Accident · 1 fatalField investigationFinal reportAerofab Lake 250 · Weirsdale, FLThe inadequate flare by the pilot-in-command on the calm water resulting in the in-flight collision with the water and subsequent nose over.NTSB SEA01LA022Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Mercer Island, WAThe pilot's failure to maintain aircraft control during a left turning step taxi to takeoff, resulting in a wing contacting the water during the step turn.NTSB IAD96LA129Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Adirondack, NYthe pilot's improper in-flight planning/decision, which resulted in his failure to ensure that he could maintain sufficient altitude and clearance from mountainous terrain after entering a blind canyon. Haze and the terrain were related factors.