NTSB investigations, MS
4 cases where NTSB found Electrical power system.
Cases per year
| 2019 | 1 |
|---|---|
| 2020 | 1 |
| 2021 | 1 |
| 2024 | 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\" = 'MS' 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\", '010224'))
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" = 'MS' 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", '010224')) 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 CEN24LA366Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Ackerman, MSThe excessive airplane speed during a no-flap landing, and the pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun. Contributing to the accident was the interference of the instrument panel wiring with the flight control…NTSB CEN21LA373Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · New Albany, MSThe pilot’s delayed decision to abort the landing that resulted in a collision with a fence post. Contributing to the accident was the failure of the alternator drive belt during cruise flight for unknown reasons and the subsequent inoperative electrical…NTSB CEN20CA087Accident · No injuriesData collectionFinal reportVans RV8 · Columbus, MSThe inadvertent engine start of the unoccupied airplane, which resulted in it moving forward and impacting a hangar and an electrical box.NTSB CEN19FA119Accident · 3 fatalClass 2 · FieldFinal reportRockwell International NA-265-65 · New Albany, MSAn unidentified electrical system malfunction that led to the pilots losing awareness of the airplane's performance in instrument meteorological conditions and resulted in a loss of control of the airplane.