NTSB investigations: Consolidated Aeronautics LAKE LA-4-200, TX
6 cases on aircraft the registry lists as Consolidated Aeronautics LAKE LA-4-200. 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
| 1978 | 1 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 2 |
| 1988 | 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\" = 'TX' 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 ('2400108'))
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" = 'TX' 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 ('2400108'))
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 FTW88LA121Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Mico, TXThe pilot said he was practicing water landings in the Lake. During a landing, the airplane started porpoising due to the wake of a passing boat. The airplane landed hard. The windsheild cracked and the pilot elected to take the airplane to the home airport…NTSB FTW82DA206Accident · No injuriesFinal reportLake LA-4-200 · Rockport, TXA partial loss of power was experienced during takeoff and a forced landing was made on a road. As the pilot was landing, a car pulled out on the road ahead of the aircraft. While manuevering to the right to avoid the car, the right wing struck a road sign…NTSB FTW82DA197Accident · No injuriesFinal reportConsolidated Aeronautics LA-4-200 · Canyon Lake, TXAfter taxiing around the shoreline, taking-off, and landing again, the pilot was unable to takeoff a second time because his left pontoon was submerging. He proceeded to drain the water out at a public boat dock and attempted to make a downwind takeoff due to…NTSB FTW81DRG17Accident · No injuriesClosedLake LA-4 · Burnet, TXNTSB FTW80FRA44Accident · No injuriesClosedLake LA-4 · Tomball, TXNTSB FTW78FRA37Accident · No injuriesClosedLake 4-200 · Tomball, TX