NTSB investigations, LA
10 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2004 | 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\" = 300)
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" = 300) 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 FTW04LA086Accident · No injuriesLimited investigationFinal reportLake LA4-270T · Crowley, LAThe pilot's inadvertant water landing with the landing gear extended. Contributing factors were the sunglare and the pilot's failure to verify the position of the flaps and landing gear.NTSB FTW98LA002Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Iberia, LAimproper touchdown by the flight instructor. A related factor was: soft sod in the touchdown/landing area.NTSB FTW92LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roanoke, LAThe locking of the main landing gear brakes.NTSB FTW85LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Houma, LAThe plt was attempting to takeoff from a short muddy strip near Houma, LA. He elected to abort the takeoff & applied brakes. The acft then rolled over a dry area on the strip, where braking action became effective & the aircraft nosed over. No mechanical…NTSB FTW84LA169Accident · No injuriesLimited investigationFinal reportCessna 172D · Belle Chasse, LAThe acfts nose gear dug into mud during landing rollout. The acft then nosed over.NTSB FTW83LA248Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Breaux Bridge, LAThe acft nosed over during landing on a wet soft private grass strip. During landing the nose gear dug in and the acft nosed over. The plt stated that he needed more experience in judging grass strip conditions.NTSB FTW83LA167Accident · No injuriesLimited investigationFinal reportCessna 185F · Int.Coastal Cty, LAThe pilot stated that the landing gear was not retracted after takeoff from the airport. When the pilot attempted to land on water the aircraft flipped over and sank. The landing gear are built into the floats and during the retraction cycle the landing gear…NTSB FTW83LA056Accident · No injuriesLimited investigationFinal reportLuscombe 8A · New Orleans, LAPilot used brakes to attempt to straighten aircraft veering in crosswind and aircraft nosed over.NTSB FTW82DA176Accident · No injuriesFinal reportCessna A185F · Houma, LAThe pilot was distracted during his approach for landing and did not utilize the checklist. He landed wheels down in water and the aircraft nosed down.NTSB FTW82DA233Accident · No injuriesFinal reportCessna 172P · Chandeleur Isla, LAWhile on a local photo and sight-seeing flight, the pilot elected to land on Chandeleur island. After landing, he prepared to depart, using the recommended soft field technique. During the takeoff, there was a strong crosswind which caused the aircraft to…