Lake LA-4-200
NTSB investigations · 71
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('5110310')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('5110310')
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 ANC76AA046Accident · 2 fatalClosedLake LA-4 · Skagway, AKNTSB SEA75FYG45Accident · No injuriesClosedLake LA-4 · Spokane, WANTSB MIA75DLD84Accident · No injuriesClosedLake LA-4 · Orlando, FLNTSB IAD75DKM22Accident · No injuriesClosedLake 4P-200 · Waynesville, NCNTSB MIA75DKT66Accident · Minor injuriesClosedLake LA-4 · Marathon, FLNTSB MIA75FKT64Accident · Serious injuriesClosedLake LA-4 · Wellingtn Lake, FLNTSB IAD75FLT08Accident · No injuriesClosedLake LA4200 · Dyersburg, TNNTSB IAD75DID08Accident · Serious injuriesClosedLake LA4200 · Weems, VANTSB NYC75FNC13Accident · No injuriesClosedLake LA-4 · Lancaster, NHNTSB FTW75DPG15Accident · No injuriesClosedLake LA-4 · Redfield, ARNTSB MIA74AM054Accident · 3 fatalClosedLake L4-200 · Bimini, Burkina FasoNTSB IAD74FIG08Accident · Serious injuriesClosedLake 4-200 · Betterton, MDNTSB CHI73DEI29Accident · No injuriesClosedLake LA-4 · Pemberville, OHNTSB MIA73RKT44Accident · Minor injuriesClosedLake LA-4 · Governors Hrbr (Atlantic Ocean)NTSB MIA73DLD37Accident · No injuriesClosedLake LA-4 · Ft Pierce, FLNTSB NYC73FIG15Accident · No injuriesClosedLake LA-4 · Rockville, MDNTSB FTW73FPD07Accident · No injuriesClosedLake LA-4 · Saginaw, TXNTSB OAK72FXO37Accident · No injuriesClosedLake LA-4 · Homewood, CANTSB CHI72FEP46Accident · No injuriesClosedLake LA-4 · Waukesha, WINTSB SEA72DYG17Accident · Minor injuriesClosedLake LA-4 · Coeur D'Alene, IDNTSB MIA71FKW51Incident · No injuriesClosedLake LA-4 · Blountville, TN
Back to Lake LA-4-200