NTSB investigations, LA
11 cases where NTSB found Temp/humidity/pressure.
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 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\" = 'LA' 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" = 'LA' 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 CEN25LA231Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Lockport, LAThe pilot’s inadequate planning for the high density altitude conditions which resulted in reduced airplane performance, climb capability, and subsequent forced landing.NTSB CEN23LA087Accident · No injuriesClass 3 · LimitedFinal reportWorld WA-3 · Shreveport, LAThe loss of engine power due to carburetor icing.NTSB CEN23LA068Accident · No injuriesClass 3 · LimitedFinal reportGrumman American AA-5B · Reserve, LAThe partial loss of engine power due to carburetor icing and the flight instructor’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing.NTSB CEN20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Welsh, LAA partial loss of engine power while in flight due to corrosion of engine components, which resulted in a loss of control and a subsequent impact with terrain.NTSB CEN20FA075Accident · 3 fatalClass 3 · FieldFinal reportCessna 182 · Chatham, LAThe pilot’s encounter with icing in-flight, which resulted in a loss of control and impact with terrain.NTSB CEN16LA064Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Sulphur, LAThe loss of engine power due to water and contaminants in the carburetor, which resulted in a forced landing to a wet field.NTSB CEN15FA426Accident · 1 fatalField investigationFinal reportJones Ralph D Zodiac CH 601 HD · Ama, LAThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack following a loss of engine power for reasons that could not be determined based on available evidence, which resulted in an aerodynamic stall and…NTSB CEN14LA251Accident · Serious injuriesLimited investigationFinal reportSmythe Donald F Kitfox Classic IV · Slaughter, LAThe pilot’s inadequate preflight planning, which resulted in his attempt to takeoff in conditions under which the airplane was unable to attain a positive rate of climb and resulted in its failure to clear trees.NTSB CEN12LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Vidalia, LAA total loss of engine power likely due to carburetor ice.NTSB CEN11LA396Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Oak Ridge, LAThe flight instructor's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and subsequent impact with trees.NTSB CEN09LA308Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Baton Rouge, LAThe partial loss of engine power due to the instructor pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing. Contributing to the accident was the instructor pilot's decision to attempt a return to the departure…