Final NTSB investigations, ND
16 cases where NTSB found Aircraft systems.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 2 |
| 2016 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 2 |
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\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0102'))
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" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0102')) 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 CEN23LA233Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-25-235 · Carrington, NDA total loss of engine power as a result of carburetor ice that formed while the engine was operating at a low power setting for an extended period of time before departure.NTSB CEN23LA103Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 425 · Bismarck, NDA loss of braking due to inadequate servicing of brake fluid by the pilot/mechanic, which resulted in a loss of airplane control on the ground.NTSB CEN22LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Grand Forks, NDFailure of the landing gear to properly extend before landing for reasons that could not be determined.NTSB CEN20LA208Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Fargo, NDFailure of the engine driven fuel pump which led to a fuel leak and subsequent fire in the engine compartment.NTSB CEN19LA219Accident · No injuriesClass 3 · LimitedFinal reportFisher Flying Products Super Koala · Hazen, NDThe airplane owner's and mechanic's improper rigging and cable tension of the aileron control system, which resulted in a loss of control during takeoff.NTSB CEN18LA097Accident · No injuriesLimited investigationFinal reportPiper PA 24-260 · Fargo, NDThe pilot's failure to use the published emergency procedures to manually extend the landing gear when an electrical failure precluded normal extension of the landing gear, resulting in the gear collapse during landing. Contributing to the accident was the…NTSB CEN17FA045Accident · 1 fatalField investigationFinal reportCessna 340 · Fargo, NDThe loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.NTSB CEN16LA098Accident · No injuriesLimited investigationFinal reportCessna 441 · Fargo, NDThe pilot’s failure to cycle the surface deice boots during the instrument approach in icing conditions, which led to ice accumulation on the leading edges of the wings and empennage, and resulted in an aerodynamic stall and subsequent hard landing.NTSB CEN12LA516Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe loss of directional control during landing roll, which resulted in a runway excursion. The reason for the loss of directional control could not be determined because postaccident examination did not reveal any malfunctions or anomalies that would have…NTSB CEN12LA444Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to adequately monitor his student's actions during the approach.NTSB CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.NTSB CEN11LA390Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe flight instructor’s inadequate supervision of the landing, which resulted in an inadequate flare and subsequent hard landing.NTSB CEN11CA071Accident · No injuriesData collectionFinal reportGrumman G-164 · Michigan, NDThe pilot's failure to abort the takeoff roll following a noticeable loss of engine power due to low engine compression and a magneto failure.NTSB CEN10CA228Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Jamestown, NDThe pilot's failure to lower the landing gear, resulting in a gear-up landing.NTSB CEN10CA026Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Grand Forks, NDThe flight instructor's failure to ensure the landing gear was extended prior to landing.NTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.