NTSB investigations, 1990, LA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1990
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") = 1990 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 FTW91FA025Accident · 1 fatalField investigationFinal reportPiper PA28-181 · Olla, LAThe collapsed carburetor float and restricted movement of the fuel metering needle. Factors were the darknight, the unsuitable terrain, and the operator's maintenance personnel failure to inspect (repair) the engine.NTSB DEN91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Welsh, LAThe pilot's improper compensation for wind conditions. A factor was the gusty wind.NTSB FTW91DRD02Accident · 2 fatalFinal reportPiper PA-J3C-65 · Mer Rouge, LAAn inadvertent stall at an altitude too low to allow for recovery.NTSB FTW91FA016Accident · 1 fatalField investigationFinal reportMBB BO 105CB4 · Cameron, LAThe company's maintenance personnel's failure to install the cyclic interconnect tube and their failure to inspect the helicopter prior to flight.NTSB FTW91DRD01Accident · No injuriesFinal reportMonnett Soneria · Lake Charles, LAA total loss of power for unknown reasons. A factor was the proximity of the crowd and other airplanes in the race during the forced landing.NTSB FTW91LA005Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's decision to enter an area of forecast thrunderstorms. The factor was the severe downdraft encountered.NTSB FTW90GA185Accident · No injuriesFinal reportHughes 369HS · New Orleans, LAThe pilot's failure to maintain rotor RPM. A factor in the accident was the lose of engine power due to fuel starvation.NTSB FTW90LA172Accident · Minor injuriesLimited investigationFinal reportBell B206BIII · Cameron, LAThe pilot's failure to jettison the external load.NTSB FTW90FA170Accident · No injuriesField investigationFinal reportAir & Space 18A · Shreveport, LAFailure of the pilot in command to follow published takeoff procedures.NTSB FTW90FA168Accident · 2 fatalField investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain flying speed which resulted in an inadvertent stall during the steep turn. A factor was the door opening in flight.NTSB FTW90FA164Accident · Serious injuriesField investigationFinal reportHughes 269C · Shreveport, LAThe pilot's failure to maintain clearance from the obstruction. Factors related to the accident were: the lack of visual ques due to the light conditions at dusk, the ground observer's lack of assistance and lack of experience in the type of operation, and…NTSB FTW90LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Saint Joseph, LAThe pilot's failure to maintain directional control and his use of excessive braking.NTSB FTW90FA152Accident · 2 fatalField investigationFinal reportCessna 150L · Leesville, LAThe pilot's failure to maintain vs while maneuvering and the fact that altitude was insufficient for recovery from the inadvertent stall.NTSB FTW90DRD15Accident · No injuriesFinal reportCessna 188 · Archibald, LAThe power loss for undetermined reasons. A factor was the rough uneven terrain in which the forced landing was performed.NTSB FTW90LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roades, LAUnknown mechanical malfunction resulting in engine oil starvation. A contributing factor was rough terrain in which the forced landing was made.NTSB FTW90DRD14Accident · 1 fatalFinal reportGrumman G-164A · Sommerset, LAThe pilot's failure to attain adequate clearance above crops at the end of the runway.NTSB FTW90DRD13Accident · 1 fatalFinal reportde Havilland DH-82A · Youngsville, LAThe pilot's failure to touch down at the proper point on the landing surface. A contributing factor was the late initiation of the aborted landing.NTSB FTW90LA143Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350D · Berwick, LAPilot in command's failure to see and avoid obstacles in the landing zone. Contributing to the accident was the pilot's lack of familiarity with the landing zone.NTSB FTW90LA118Accident · No injuriesLimited investigationFinal reportBell TH13T · Paradise, LAThe failure of the pilot to properly execute the autorotation landing.NTSB FTW90FA119Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bossier City, LALoss of engine power for an unknown reason.NTSB FTW90DRD12Accident · Minor injuriesFinal reportGrumman G-164A · Bastrop, LAThe pilot's improper engine procedures during ground operations and prior to takeoff which resulted in fouled spark plugs.NTSB FTW90LA115Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandeleur Isld, LAMinimum airspeed required for flight (vs) was not maintained. Contributing factors were the pilot's fatigued condition, and premature lift off.NTSB FTW90DRD11Accident · No injuriesFinal reportBell 47G3-B · Houma, LAThe pilot's failure to maintain rotor RPM and an excessive sink rate.NTSB FTW90DRD10Accident · No injuriesFinal reportGrumman G-164B · Mamou, LAPilot misjudged wind information. Factors contributing to the accident were the tailwind, the trees and the levee.NTSB FTW90FA111Accident · No injuriesField investigationFinal reportSchweizer 269C · Tallulah, LALoss of control due to a multiple bird strike and incorrect control inputs by the pilot in the flare. Contributing factors were the bird strike induced vibrations and the main rotor blade contact with the tail rotor drive shaft.NTSB FTW90DRD08Accident · No injuriesFinal reportSchweizer G-164B · Basile, LAThe pilot's inadequate evaluation of the weather information. A related factor to the accident was the tailwind.NTSB FTW90LA107Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kaplan, LARestricted movement of the right skid assembly causing the lateral center of gravity to be exceeded during the attempted take off.NTSB FTW90DRD07Accident · No injuriesFinal reportGrumman G-164A · Ville Platte, LAPartial loss of engine power due to a cracked number four cylinder intake rocker box housing. The lack of a suitable forced landing site was a related factor.NTSB FTW90DRD06Accident · Serious injuriesFinal reportStolt Acroduster II · Alexandria, LAThe pilot misjudged the landing flare.NTSB FTW90DRD05Accident · No injuriesFinal reportSchweizer G-164B · Reeves, LALoss of engine power due to a frozen rocker arm.NTSB FTW90FA094Accident · 1 fatalField investigationFinal reportBeech B35-C33A · Le Compte, LAThe pilot's continuation of VFR flight into IMC. Factors were the pilot's failure to obtain a pre-flight weather brief and his inadequate evalution of existing weather.NTSB FTW90DRD04Accident · No injuriesFinal reportGrumman G-164B · Fenton, LAFailure of the elevator control rod end bearing.NTSB FTW90LA082Accident · Serious injuriesLimited investigationFinal reportCessna 177A · Leesville, LALoss of engine power for undetermined reasons. Contributing to the accident were the rough tree covered terrain in which the forced landing was performed and the bright night conditions.NTSB FTW90LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bastrop, LAFailure of the pilot to maintain adequate airspeed for a go-around, which resulted in an inadvertent stall. Factors related to the accident were: the unfavorable wind condition and turbulence.NTSB FTW90LA074Accident · No injuriesLimited investigationFinal reportHughes 269C · Houma, LALoss of engine power for an unknown reason.NTSB FTW90DRD03Accident · No injuriesFinal reportGrumman G-164A · Glynn, LALoss of directional control on the ground, due to intermittent locking of the right brake during the landing roll.NTSB FTW90LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rayne, LAFailure of the #3 exhaust valve, which necessitated a forced landing on unsuitable terrain.NTSB FTW90DRD02Accident · No injuriesFinal reportC&J Sontheimer Rotorway · Lake Charles, LAFailure of the tail rotor drive belt.NTSB FTW90LA054Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Bastrop, LALoss of engine power due to water contamination in the fuel. A factor related to the accident was: inadequate design of the fuel system drains, which prevented an adequate preflight of the fuel system.NTSB FTW90LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hammond, LAPilot in command's initiation and continuation of the flight into an area of known IMC weather conditions and his subsequent inability to land prior to running out of fuel. Contributing factors to the accident were the pilot's failure to exercise good…