NTSB investigations, 2011, LA
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1963 | 3 |
| 1964 | 120 |
| 1965 | 109 |
| 1966 | 108 |
| 1967 | 118 |
| 1968 | 100 |
| 1969 | 100 |
| 1970 | 91 |
| 1971 | 75 |
| 1972 | 75 |
| 1973 | 88 |
| 1974 | 84 |
| 1975 | 105 |
| 1976 | 93 |
| 1977 | 106 |
| 1978 | 108 |
| 1979 | 103 |
| 1980 | 110 |
| 1981 | 95 |
| 1982 | 78 |
| 1983 | 57 |
| 1984 | 72 |
| 1985 | 57 |
| 1986 | 47 |
| 1987 | 33 |
| 1988 | 36 |
| 1989 | 41 |
| 1990 | 40 |
| 1991 | 26 |
| 1992 | 25 |
| 1993 | 32 |
| 1994 | 25 |
| 1995 | 22 |
| 1996 | 40 |
| 1997 | 28 |
| 1998 | 27 |
| 1999 | 28 |
| 2000 | 26 |
| 2001 | 28 |
| 2002 | 26 |
| 2003 | 21 |
| 2004 | 27 |
| 2005 | 32 |
| 2006 | 18 |
| 2007 | 15 |
| 2008 | 13 |
| 2009 | 21 |
| 2010 | 16 |
| 2011 | 28 |
| 2012 | 23 |
| 2013 | 19 |
| 2014 | 19 |
| 2015 | 20 |
| 2016 | 21 |
| 2017 | 17 |
| 2018 | 18 |
| 2019 | 21 |
| 2020 | 23 |
| 2021 | 23 |
| 2022 | 16 |
| 2023 | 16 |
| 2024 | 26 |
| 2025 | 17 |
| 2026 | 10 |
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 year(c.\"eventDate\") = 2011
AND c.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2011 AND c."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' 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 CEN12CA119Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II · Loreauville, LAThe student pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.NTSB CEN12LA076Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · New Orleans, LAA loss of engine power due to detonation of the No.2 cylinder from a clogged fuel injector nozzle.NTSB CEN12CA030Accident · No injuriesData collectionFinal reportCessna 172N · Covington, LAThe pilot’s failure to maintain adequate airspeed during a banner drop, resulting in an aerodynamic stall.NTSB CEN12CA027Accident · No injuriesData collectionFinal reportMichael Cans RV-8 · Breaux Bridge, LAThe pilot's failure to maintain control of the airplane after striking an unseen sinkhole during landing.NTSB CEN12LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Vidalia, LAA total loss of engine power likely due to carburetor ice.NTSB CEN11LA415Accident · Serious injuriesLimited investigationFinal reportBins Tom Kitfox IV · Lafayette, LAThe pilot’s loss of control during a forced landing after a loss of engine power for undetermined reasons during takeoff.NTSB CEN11IA615Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Baton Rouge, LAThe improperly installed upper attachment bolt in the left main landing gear uplock assembly, which led to the failure of the left main landing gear to extend before landing. Contributing to the accident was maintenance personnel's lack of training on the…NTSB CEN11CA580Accident · No injuriesData collectionFinal reportCessna 172N · Winnsboro, LAThe pilot's failure to maintain aircraft control during takeoff with a gusting crosswind.NTSB CEN11LA529Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Opelousas, LAThe loss of engine power due to fuel contamination.NTSB CEN11LA472Accident · No injuriesLimited investigationFinal reportCessna 150J · Lacassine, LAA total loss of engine power due to fuel exhaustion, as a result of the pilot's improper fuel planning.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 CEN11CA336Accident · Serious injuriesData collectionFinal reportReed Roderick KB3 Gyroplane · Scott, LAThe pilot's poor decision to takeoff with a tailwind which resulted in a runway excursion.NTSB CEN11FA319Accident · 1 fatalField investigationFinal reportThomas Europa · Shreveport, LAThe loss of aircraft control and subsequent impact with terrain for undetermined reasons.NTSB CEN11FA292Accident · Minor injuriesField investigationFinal reportPiper PA-22/20 · New Orleans, LAThe pilot’s inadequate in-flight fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB CEN11CA303Accident · Minor injuriesData collectionFinal reportBell 206 · Venice, LAThe pilot's improper use of the collective and cyclic control during taxi operations, which induced a dynamic rollover.NTSB CEN11LA283Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lake Charles, LAThe pilot's loss of control of the helicopter while in a hover.NTSB CEN11IA286Incident · No injuriesIncident investigationFinal reportCessna 560XL · Abbeville, LAThe pitch trim control cable failed due to fatigue, rendering the elevator trim inoperative.NTSB CEN11LA311Accident · No injuriesLimited investigationFinal reportMooney M20K · New Orleans, LAA loss of electrical and engine power for undetermined reasons.NTSB DCA11IA040Incident · No injuriesIncident investigationFinal reportAirbus A320 · New Orleans, LAthe captain's failure to properly recognize and manage the abnormal condition, resulting in it escalating to an in-flight emergency.NTSB CEN11CA232Accident · No injuriesData collectionFinal reportBell 230 · Gulf of Mexico, LAThe pilot's failure to maintain adequate clearance from the safety skirting during the repositioning landing.NTSB CEN11CA231Accident · No injuriesData collectionFinal reportHiller UH-12D · Iowa, LAThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.NTSB CEN11CA216Accident · No injuriesData collectionFinal reportCessna A185F · Belle Chase, LAThe pilot's failure to ensure that the landing gear was retracted for the water landing.NTSB CEN11CA206Accident · No injuriesData collectionFinal reportWaco SRE · Vidalia, LAThe pilot’s failure to maintain directional control during landing in gusty wind conditions.NTSB CEN11CA211Accident · Minor injuriesData collectionFinal reportPiper PA-34-220T · Bogalusa, LAThe pilot’s inadequate flare after encountering a gust of wind on landing.NTSB CEN11CA221Accident · No injuriesData collectionFinal reportCessna 150L · Gonzales, LAThe flight instructor's failure to monitor the available fuel supply, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11CA171Accident · No injuriesData collectionFinal reportCessna 172R · Shreveport, LAThe student pilot's loss of directional control during the landing.NTSB CEN11IA156Incident · No injuriesIncident investigationFinal reportSikorsky 92 · Galliano, LAThe misalignment of the retaining washer during routine maintenance, resulting in the subsequent separation of the washer and nut.