NTSB investigations: Dornier Luftfahrt 328-100
5 cases on aircraft the registry lists as Dornier Luftfahrt 328-100. 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
| 2000 | 1 |
|---|---|
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2012 | 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.aircraft_model_code IN ('2996100'))
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.aircraft_model_code IN ('2996100'))
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 DCA12WA040Incident · No injuriesForeign investigationDornier 328 · Reykjavik, IcelandThe Iceland Air Accident Investigation Board (AAI) has notified the NTSB of an incident involving a Dornier D328 that occurred on February 20, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…NTSB NYC04IA116Incident · No injuriesIncident investigationFinal reportDornier DO-328-100 · Allentown, PAThe opening of the main cabin door after takeoff, for undetermined reasons.NTSB NYC02IA117Incident · Minor injuriesIncident investigationFinal reportDornier 328 · Washington, DCThe ground service personnel's failure to follow company procedure, which resulted in the flight attendant sustaining a serious injury.NTSB NYC01LA096Accident · Serious injuriesLimited investigationFinal reportDornier 328-100 · Springfield, VAAn inadvertent encounter with turbulence during descent.NTSB DEN00FA063Accident · No injuriesField investigationFinal reportDornier 328-100 · Denver, COuncommanded retraction of the nose and right main landing gears during landing roll for reasons undetermined.