NTSB investigations: Culver LCA
13 cases on aircraft the registry lists as Culver LCA. 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 | 3 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1971 | 2 |
| 1978 | 1 |
| 1980 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2005 | 1 |
| 2019 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8730202'))
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 ('8730202'))
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 CEN19LA243Accident · Serious injuriesClass 3 · LimitedFinal reportCulver LCA · Viroqua, WIA total loss of engine power due to fuel exhaustion.NTSB DFW06CA002Accident · Minor injuriesData collectionFinal reportCulver LCA · McGregor, TXThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL94FA043Accident · 2 fatalField investigationFinal reportCulver LCA · Lake City, SCWas the pilot's failure to maintain flying speed while maneuvering the airplane which resulted in the loss of control and the collision with the ground.NTSB LAX93LA265Accident · No injuriesLimited investigationFinal reportCulver LCA · San Luis Obispo, CAThe pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the pilot's lack of recent flight experience in tail wheel aircraft.NTSB LAX80FUQ08Accident · 2 fatalClosedCulver LCA · Mojave, CANTSB FTW78FRD20Accident · Serious injuriesClosedCulver LCA · Lafayette, LANTSB MKC71FDM56Accident · No injuriesClosedCulver Cadet · Faribault, MNNTSB OAK71AP033Accident · 1 fatalClosedCulver LCA · Dos Palos, CANTSB DIA68F0108Accident · Serious injuriesClosedCulver LFA · Middletown, DENTSB CHI66F0497Accident · No injuriesClosedCulver LCA · Superior, WINTSB UNK64X4056Accident · 3 fatalClosedCulver LCA · Northfield, VANTSB UNK64X3391Accident · No injuriesClosedCulver LCA · Menominee, MINTSB UNK64X2030Accident · No injuriesClosedCulver LCA · Weyers Cave, VA