NTSB investigations, AR
14 cases where NTSB found Temp/humidity/pressure.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 2 |
| 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\", '030310'))
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", '030310')) 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 CEN16LA025Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Sheridan, ARThe partial loss of engine power due to carburetor icing.NTSB GAA15CA202Accident · Minor injuriesData collectionFinal reportBell 47G · De Queen, ARThe pilot's failure to conduct helicopter performance planning, which resulted in an uncontrolled descent and impact with a truck and terrain during takeoff from an elevated platform.NTSB CEN14LA308Accident · No injuriesLimited investigationFinal reportGulfstream Schweizer A/C Gulfstream AM G 164C · Beech Grove, ARThe pilot’s inadequate preflight planning, which resulted in his attempt to take off with insufficient climb performance to climb out of ground effect in the high-density altitude conditions.NTSB CEN14LA299Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Dell, ARThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight in high-density altitude and gusting crosswind conditions.NTSB CEN14CA258Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hunter, ARThe pilot's downwind takeoff from a grass airstrip, which resulted in inadequate climb performance and the subsequent impact with terrain.NTSB CEN13LA198Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Rogers, ARThe pilot’s failure to maintain control due to a sudden turbulence encounter while on final approach. Contributing to the accident was ice buildup on the wings’ leading edges.NTSB CEN12CA422Accident · No injuriesData collectionFinal reportCessna 172K · Greers Ferry, ARThe pilot’s failure to maintain a positive rate of climb while taking off with a high density altitude.NTSB CEN12LA331Accident · Minor injuriesLimited investigationFinal reportBaldwin Skybolt · Stuttgart, ARThe pilot's inadequate preflight planning, which resulted in the airplane’s overweight takeoff from an airstrip with a high density altitude and subsequent collision with terrain.NTSB CEN12LA306Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Marion, ARThe partial loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN10LA555Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Pocahontas, ARThe pilot's failure to abort the takeoff in a timely manner. Contributing to the accident was the weight of the airplane and the high ambient temperature.NTSB CEN10CA265Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Roe, ARThe pilot's decision to take off with a tailwind, resulting in a runway overrun.NTSB CEN09FA393Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Lakeview, ARThe pilot's poor judgment/decision making in attempting the no-flap takeoff, his failure to comply with weight and balance limitations, and his failure to calculate the airplane's performance under exiting conditions.NTSB DFW08CA199Accident · No injuriesData collectionFinal reportGrumman G-164A · Newport, ARThe pilot's failure to maintain aircraft control. Contributing factors were the high temperature and tailwind.