NTSB investigations, MO
5 cases where NTSB found Runway/taxi/approach light.
Cases per year
| 2014 | 1 |
|---|---|
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
Where
Latest 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\" = 'MO' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022012'))
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" = 'MO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022012')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 GAA19CA443Accident · No injuriesData collectionFinal reportValldejuli John A Aerocomp · Jefferson City, MOThe pilot's failure to maintain directional control during a touch-and-go landing in gusting crosswind conditions, which resulted in a runway excursion, impact with runway lights, and a nose-over.NTSB GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.NTSB CEN18LA220Accident · No injuriesLimited investigationFinal reportBeech A23 · Sedalia, MOThe pilot’s loss of directional control during the landing rollout due to the unexpected wind shift, which resulted in a runway excursion.NTSB GAA17CA498Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Perryville, MOThe pilot’s failure to maintain directional control during takeoff.NTSB CEN14LA333Accident · No injuriesLimited investigationFinal reportCessna 172R · Joplin, MOThe partial loss of engine power for reasons that could not be determined because an operational test run of the engine did not reveal any anomalies that would have precluded normal operation.