NTSB investigations, AR
4 cases where NTSB found Powerplant parameters.
Cases per year
| 2013 | 2 |
|---|---|
| 2023 | 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\" = 'AR' 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\", '01062050'))
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" = 'AR' 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", '01062050')) 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 CEN24FA095Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Little Rock, ARThe pilot’s failure to maintain airplane control after a partial loss of engine power during initial climb. Contributing to the accident was the pilot’s failure to follow airplane flight manual procedures and limitations for the turbocharged engine, which…NTSB CEN23FA258Accident · 1 fatalClass 3 · FieldFinal reportCessna 177 · Hot Springs, ARThe pilot’s improper preflight fuel planning and inflight fuel mismanagement, which resulted in a total loss of engine power due to fuel exhaustion, and his subsequent failure to maintain adequate airspeed during the forced landing, which resulted in the…NTSB CEN13LA504Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Walnut Ridge, ARThe pilot's failure to properly set the engine power for takeoff, which resulted in the airplane subsequently settling into terrain.NTSB CEN13LA402Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Tillar, ARThe loss of engine throttle control during takeoff due to an unsecured cockpit throttle control pin, which resulted in a runway overrun.