NTSB investigations, LA
11 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1996 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
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 c.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 FTW03LA135Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Bossier City, LAThe failure of the passenger to follow the pilots landing instructions.NTSB FTW02LA138Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Alsatia, LAThe main rotor contact to the tail boom resulting from the pilot leaving the helicopter unattended while the rotors were engaged.NTSB FTW01LA067Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS.125-700A · New Orleans, LAthe pilot-in-command's inadequate preflight inspection, which resulted in a flight with a blocked fuel tank vent. A contributing factor was maintenance personnel's failure to remove the tape covering the fuel tank vent following a pressure test.NTSB FTW96LA355Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Clinton, LAthe instructor pilot's failure to follow recommended procedures to properly brace himself in preparation for landing.NTSB FTW96LA140Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S49A · Vidalia, LAthe pilot-in-command's inadequate supervision of the ground crewmember.NTSB FTW94FA279Accident · No injuriesField investigationFinal reportDassault DA 200 · New Orleans, LAThe captain's decision to abort the takeoff after accelerating past V1. A factor was the fluctuating engine instrument for undetermined reasons.NTSB FTW92LA183Accident · No injuriesLimited investigationFinal reportCessna 180K · Curlew Island, LAThe pilot's selection of unsuitable terrain for landing. A factor was the pilot's physical impairment.NTSB FTW92FA112Accident · 2 fatalField investigationFinal reportBell 206L-3 · Venice, LAThe pilot's incapacitation due to food poisoning.NTSB DEN91LA036Accident · 1 fatalLimited investigationFinal reportCessna 180K · Patterson, LAThe pilot's failure to identify an unsafe or hazardous condition. Factors were: rough water and high winds.NTSB FTW86FA031Accident · 2 fatalField investigationFinal reportPiper PA-31P-350 · Norco, LAThe plt initiated an ILS apch in below minimum weather conditions shortly after night fall. He was given a low alt alert, but continued the apch. He announced a missed apch, and indicated problems climbing to alt. He then declared an unspecified emergency,…NTSB FTW83IA005Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Kenner, LAThe plt departed with a tail wind which exceeded the allowable component. Rotation was observed to have occurred at the departure threshold. The acft was estimated to be at 25 to 30 ft AGL when it was 1330 ft beyond the departure end of therunway. Two persons…