NTSB investigations: Honda CIVIC
11 cases on aircraft whose registry engine model is Honda CIVIC. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1975 | 1 |
|---|---|
| 1978 | 1 |
| 1980 | 2 |
| 1988 | 1 |
| 1992 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2012 | 1 |
| 2020 | 1 |
| 2024 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('33802'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('33802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA24LA255Accident · Minor injuriesClass 3 · LimitedFinal reportTitan T51 · Madisonville, TNThe failure of the right main landing gear weldment due to fatigue cracking.NTSB CEN20LA375Accident · 1 fatalClass 3 · LimitedFinal reportTitan Mustang T-51 · Brighton, COThe pilot’s loss of airplane control while maneuvering in the traffic pattern.NTSB CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.NTSB LAX03LA209Accident · Serious injuriesLimited investigationFinal reportDavis LG2H · Salome, AZThe pilot's excessive use of the controls during an aborted takeoff, and his failure to maintain airspeed which resulted in a stall/mush. Factors in the accident include the pilot's lack of familiarity with the airplane and an excessively rich mixture setting…NTSB ATL02LA087Accident · No injuriesLimited investigationFinal reportGreg Grouleff BD-5B · Bessemer, ALThe pilot's improper landing flare that resulted in a hard landing and the fracture of the left main landing gear casting.NTSB ATL93LA023Accident · 1 fatalLimited investigationFinal reportBede BD-5B · Guntersville, ALThe pilot's inadvertent stall of the airplane, during the base to final turn, at too low an altitude to effect recovery. Factors were the improper lift off, which resulted in the airplane re contacting the runway after lift off, and served to distract the…NTSB DEN88DTE06Accident · No injuriesFinal reportHelfrich-Leonard BD-5B · Englewood, COThis experimental acft is powered by a modified honda 1250 cc, watercooled eng. The plt reported that after takeoff the eng temp reached the redline and the eng lost power. During the forced landing the main landing gear collapsed. Examination of the eng…NTSB MKC81FCG19Accident · No injuriesClosedBede BD-5B · Springfield, MONTSB FTW81FRA09Accident · Serious injuriesClosedBede BD-5 · Tomball, TXNTSB DEN78FTE78Accident · No injuriesClosedBede 5-B · Longmont, CONTSB LAX76FUG08Accident · Minor injuriesClosedBede BD-5 · Chino, CA