NTSB investigations, DC
9 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 'DC' 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" = 'DC' 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 OPS07IA010Incident · No injuriesIncident investigationFinal reportLearjet 35 · Washington, DCThe probable cause of this incident was the IAD tower local controller's failure to ensure that the runway was free of all known ground vehicles, equipment, and personnel before permitting a departing aircraft to start takeoff roll. Additionally, the…NTSB NYC06MA131Accident · 1 fatalMajor investigationFinal reportEurocopter EC-135P1 · Washington, DCThe operator's inadequate training program and the pilot's failure to maintain control of the helicopter following his inadvertent disabling of the No. 1 and then the No. 2 engine full authority digital engine control system.NTSB DCA05MA070Accident · 1 fatalMajor investigationFinal reportEmbraer 170 · Washington, DCThe inexperience of the driver (fleet service agent) in the operation of a belt loader, which resulted in the belt loader being driven under, and colliding with, the airplane.NTSB DCA04IA052Incident · No injuriesIncident investigationFinal reportAirbus Industrie A340-311 · Washington, DCThe incorrect loading of baggage into the aft cargo compartment instead of the forward compartment, which resulted in aft CG light in-flight.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 BFO87FA053Accident · 1 fatalField investigationFinal reportBoeing 747-200B · Washington, DCA flight attendant fell from the acft during opening of the L5 door. The f/a was helping a company ground person, who was outside on the boarding step. The boarding step was not against the acft but about 1 ft away from it. When the door was opened, the f/a…NTSB FTW84IA389Incident · No injuriesIncident investigationFinal reportDassault/Sud FAN JET Falcon · Washington, DCAprx 1-1/2 hrs after take-off, the capt took sinus medication. Aprx 30 minutes later, he complained of a headache, took tylenol & alka seltzer & went to the cabin to lie down. The capt was incapacitated for the rest of the flt. The coplt & a plt rated pax…NTSB ATL84IA024Incident · No injuriesIncident investigationFinal reportBritish 1-11/204/AF · Washington, DCOn initial climb but the foward right galley service door blew open for undetermined reasons. The acft returned and landed without further incident. The door warning light did not come on.NTSB ATL83IA085Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Washington, DCThe acft was observed by witnesses to descend below its normal descent path and to horizontially stray off course to thepoint that office bldg occupants and persons on the ground were concerned by the appearance and noise of the acft duringa vor/dme approach…